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.
Last edited by sahar; 07-08-2011 at 12:33 PM.
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.)
Making the world a better place one fret at a time
||||||
If someone helped you, please click on the star icon at the bottom of their post
If your problem is solved, please update the first post:
EDIT, Go Advanced button, set Prefix to SOLVED
[code]
' Enclose code in tags like this
[/code]
Don't attach a screenshot--just attach your Excel file! It's easier and will let us experiment with your data, formulas, and code.
Thanks 6StringJazzer. It is exactly what I was looking for.
I have a question that's again very closely related so I did not want to start a new thread. If it's against the rules please let me know and I will begin a new thread. While 6StringJazzers solution works for a normal drop down list 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.
Once again any help will be appreciated.
Thank you.
My solution only cares about what value the user selected from the list, not how the list choices are built.
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?Originally Posted by sahar
Making the world a better place one fret at a time
||||||
If someone helped you, please click on the star icon at the bottom of their post
If your problem is solved, please update the first post:
EDIT, Go Advanced button, set Prefix to SOLVED
[code]
' Enclose code in tags like this
[/code]
Don't attach a screenshot--just attach your Excel file! It's easier and will let us experiment with your data, formulas, and code.
Hello again,
I am attaching my sheet here. On the Basic Input Sheet I am trying to hyperlink the sheets in the cell adjacent to the To Proceed cell based on the sheet selected in the Process Being Used Drop Down List.
Thanks.
PS: You'll find all the lists on the "Worksheet" Sheet at the end.
I was able to get it to work like this, by adding single quotes around the sheet name (although I'm not sure why, because it doesn't contain spaces). You posted it with a different file name; I also had to save it with the original file name (as below) to get it to work.
=HYPERLINK("[Bid.xlsx]'"&K19&"'!A1","Please Click Here")
Thanks again 6StringJazzer that worked perfectly.
I am using your Hyperlink formula, but keep getting "Cannot open specified file" (getting same error when clicking on link in your sample).
Help?
Re: Creating Hyperlinks to Worksheets as per Value selected in Dependent Drop Down List
this thread is a life saver. Thank you Very MUCH!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks