Can you please share a example file.





On Saturday, December 19, 2015 at 12:19:36 AM UTC+5:30, Akash Maheshwari wrote:
Hi Team,

Can someone help me with a code.

I have one sheet with the name as Go_To. In this sheet I have dates mentioned from 1st Jan to 31st Dec.

I have one more sheet with the name as Status_Report. The sheet has been designed day wise.

What I want is if I click on a specific date on Go_To sheet it shld take me to specific cell on the sheet named as Status_Report.

I can do it using Hyperlink but it wld be a too leanthy process. Can someone help me with a code for the same.

Awaiting for a helping hand.

Rgds

Akash Maheshwari