Forum Discussion
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...
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)