Help with drop down box and links to pages in same workbook

Copper Contributor

Good afternoon all,

 

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.

1 Reply
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.