I have an "At-A-Glance" sheet where I want to install hyperlinks to get to a detailed view sheet, but I don't want to have to constantly maintain 30+ sheets when I can make it interactive. I am wondering if the hyperlink for the department on the "At-A-Glace" sheet can refer to the department name in the dropdown list. Example: If I click on the Hyperlink for Energy Manager in At-A-Glance, it would go to the detailed view sheet and select the Energy Manager in the dropdown. Is this possible? If not, what are my options for this?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Can you have a hyperlink connect to a specific word in a dropdown list?
- Thread starter ReneeDJ73
- Start date
