Creating Hyperlinks to Worksheets as per Value selected in Dependent Drop Down List

Hi everyone,

I apologize if this topic has been covered in some other thread but I looked really well and couldn't really find anything.

I have multiple worksheets in a excel file. On the first sheet I have a drop down list with the names of all the other sheets.

What I want to do is as follows -
In another cell (on the same worksheet as the drop-down list) I want to create a hyperlink to the other worksheets but I want the hyperlink to reach the worksheet which has been selected in the drop down list. So, basically I want one hyperlink to work as a connection to different sheets based on the value selected in the drop-down list.

Is this even possible?

Thanks,
Sahar.

Welcome to the Forum!

See attached for a simple example. The key is to use the HYPERLINK function. (Edit: I assumed that when you say "dropdown box" you are talking about list validation, rather than a combobox control.)

My solution only cares about what value the user selected from the list, not how the list choices are built.

Originally Posted by sahar

...it does not work for a dependent drop down list.

Specifically, I want a hyperlink to be created based on the value in a drop down list but this drop down list is a dependent on another drop down list.

I'm not sure I understand what you've done here. Can you describe what is in the list, and how you build it, or attach an example?

totallycluelessabout, you have asked a question that is unrelated to the original question, and have done so in a thread that is three years old. As a new user, please take the time to review our rules. There aren't many, and they are all important.

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.