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