Dear All,
Again I'm here to make my excel sheet more featured.I want to add a logic from VB in excel to make my sheet more flexiable.
I have 5 sheets and sheet name are 1,2,3,4,5(Name the sheets as 1, 2, 3, 4, 5)
Now I want to add a button in each page. Now suppose today date is 27 as already I've named all sheet according date i.e,1,2,3...31 and suppose I'm in sheet no. 5 so I soon want to reach sheet no. at 27 for this purpose how to implement button in all sheets.
Note:- User will reach at destination sheet on click event of button on the basis of today's date.
Please give me step by step proper solution.
Thanks and Regards
Ravindra Bisht
Again I'm here to make my excel sheet more featured.I want to add a logic from VB in excel to make my sheet more flexiable.
I have 5 sheets and sheet name are 1,2,3,4,5(Name the sheets as 1, 2, 3, 4, 5)
Now I want to add a button in each page. Now suppose today date is 27 as already I've named all sheet according date i.e,1,2,3...31 and suppose I'm in sheet no. 5 so I soon want to reach sheet no. at 27 for this purpose how to implement button in all sheets.
Note:- User will reach at destination sheet on click event of button on the basis of today's date.
Please give me step by step proper solution.
Thanks and Regards
Ravindra Bisht