Forum Discussion

grizzer0117's avatar
grizzer0117
Copper Contributor
Oct 18, 2024

Create a drop down menu to link to different sheets within an excel workbook

Hello.  I have an Excel workbook that has 60 different worksheets. Each worksheet has it's own name (ie. 15-1157, 23-BR10, 24-VH02, etc).  I wanted to create a dropdown list to navigate to each sheet.  I've created a list and have made the dropdown from the list.  I tried to use the following formula in a cell next to the dropdown list:  =HYPERLINK(CONCAT("#",D1,"!A3"),"GO").  D1 is the location of the dropdown list result.  I get a "reference isn't valid" error.  Is there something missing from the formula?

 

Some info about the worksheets:

The dropdown list and Cell D1 (location of the list result) are both formatted as "General"

Calculations are set to Automatic

 

Unfortunately I cannot use visual basic or any macros so using a formula is my only option. 

 

 

excel

2 Replies

  • grizzer0117's avatar
    grizzer0117
    Copper Contributor
    Oct 18, 2024

    @HansVogelaar,

      Thanks for the advice.  I was able to get it working by removing the dashes in the worksheet names and dropdown list (had 17-1157, 20-RC03, etc and changed to 171157, 20RC03, etc)

Resources