Forum Discussion

Copper Contributor

Apr 15, 2020

Link to different sheets based on cell value

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...

excel

Formulas and Functions

sammage34

Copper Contributor

Apr 15, 2020

tbula

That formula works great! Now is there any way to use that formula in a shape that I can use as a button?

tbula

Copper Contributor

Apr 16, 2020

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 differentsammage34