I am trying to create a drop down list in excel that will contain links to worksheets in the same workbook. I have 28 worksheets in the same workbook and it would be nice to be able to select which page I want to work on from a single drop down list. I am using office 365 (excel for mac) on a macbook pro. Any help will be greatly appreciated. Thank you in advance.
If your drop-down list for Sheet Names is in A2, you may enter this HYPERLINK formula in B2, assuming you always want to link to A1 of each Sheet: =HYPERLINK(“#’”&A2&”’!A1”,A2) The foregoing formula links to A1 of the Sheet Name identified in A2 and displayed as link in B2.