Forum Discussion
CharlesK1735
May 30, 2019Copper Contributor
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 ...
Twifoo
May 30, 2019Silver Contributor
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.
=HYPERLINK(“#’”&A2&”’!A1”,A2)
The foregoing formula links to A1 of the Sheet Name identified in A2 and displayed as link in B2.