Apr 14 2020 07:34 PM
I have a sheet that I can add a lot of dated information to, and then 12 more sheets, one for each month. I would like to have a button with a link set up that will go to the current month sheet. The current month is April, so click on the current month button and it will take me to the April worksheet.
Is there a way to do this?
Apr 14 2020 08:04 PM
if the current month April is in the cell "A1" and you have got the sheet named "April"
you can use the formula: =HYPERLINK("#"&A1&"!A1",A1)
Apr 15 2020 01:34 AM
That formula works great! Now is there any way to use that formula in a shape that I can use as a button?
Apr 15 2020 09:00 PM
I am afraid it is hard to use the formula to make a botton, but maybe you can set the color for the cell to make it different@sammage34