Home

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

%3CLINGO-SUB%20id%3D%22lingo-sub-659004%22%20slang%3D%22en-US%22%3EHelp%20with%20drop%20down%20box%20and%20links%20to%20pages%20in%20same%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-659004%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20afternoon%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20create%20a%20drop%20down%20list%20in%20excel%20that%20will%20contain%20links%20to%20worksheets%20in%20the%20same%20workbook.%20%26nbsp%3BI%20have%2028%20worksheets%20in%20the%20same%20workbook%20and%20it%20would%20be%20nice%20to%20be%20able%20to%20select%20which%20page%20I%20want%20to%20work%20on%20from%20a%20single%20drop%20down%20list.%20%26nbsp%3BI%20am%20using%20office%20365%20(excel%20for%20mac)%20on%20a%20macbook%20pro.%20%26nbsp%3BAny%20help%20will%20be%20greatly%20appreciated.%20%26nbsp%3BThank%20you%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-659004%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Eexcel%20for%20mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-659041%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20drop%20down%20box%20and%20links%20to%20pages%20in%20same%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-659041%22%20slang%3D%22en-US%22%3EIf%20your%20drop-down%20list%20for%20Sheet%20Names%20is%20in%20A2%2C%20you%20may%20enter%20this%20HYPERLINK%20formula%20in%20B2%2C%20assuming%20you%20always%20want%20to%20link%20to%20A1%20of%20each%20Sheet%3A%3CBR%20%2F%3E%3DHYPERLINK(%E2%80%9C%23%E2%80%99%E2%80%9D%26amp%3BA2%26amp%3B%E2%80%9D%E2%80%99!A1%E2%80%9D%2CA2)%3CBR%20%2F%3EThe%20foregoing%20formula%20links%20to%20A1%20of%20the%20Sheet%20Name%20identified%20in%20A2%20and%20displayed%20as%20link%20in%20B2.%3C%2FLINGO-BODY%3E
CharlesK1735
Occasional Visitor

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.