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

excel
Formulas and Functions

3 Replies

  • 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