Forum Discussion

CharlesK1735's avatar
CharlesK1735
Copper Contributor
May 30, 2019

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

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.

Excel for Mac

1 Reply

Sort By
  • Twifoo's avatar
    Twifoo
    Silver Contributor
    May 30, 2019
    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.

Resources