Excel Hyperlink

[Lady123]

I ‘m trying to create an Excel Hyperlink from a data validation box. When I select Procurement from the data validation box and “Click Me” the link takes me to sheet called “List” but I want the link to take me to sheet 1 column B26 where Procurement is located.

Attached is my test file.

Thank you!

[AliGW]

Administrative Note:

Is your forum profile showing ONLY the oldest Excel PRODUCT that you need this to work for?

Members will tailor the solutions they offer to the Office PRODUCT (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your product is for Mac, please also state this.

The three most recent Excel products are Excel 2019, Excel 2021 and MS365 - if you are using MS365, please give this name along with the version number in your profile (e.g. MS365 Version 2306). This is in the About Excel section further down the Account page.

Thanks.

[Lady123]

Hello, Thank you for your help. I just updated my profile to indicate my excel version is for a PC and is MS365, version 2308.
Thanks

[Mumps1]

Copy and paste this macro into the worksheet code module. Do the following: right click the tab name for your sheet and click 'View Code'. Paste the macro into the empty code window that opens up. Close the code window to return to your sheet. Make a selection in the drop down in B1.

Please Login or Register  to view this content.

[Lady123]

Thank you Mumps1 !!!
I tried it and it worked perfectly.

[Mumps1]

You are very welcome.