Forum Discussion

sammage34's avatar
sammage34
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
tbula's avatar
tbula
Copper Contributor
Apr 15, 2020

sammage34 

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)

  • sammage34's avatar
    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's avatar
      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 

Resources