I have a sheet named "LinkSheet" that contains a list of hyperlinks. I’d like to create a dropdown list on a separate sheet that allows users to select one of these links and navigate directly to the corresponding hyperlink.
I initially tried using Data Validation to create the dropdown, but it seems Data Validation doesn’t support clickable hyperlinks in this context. I’m open to alternative solutions — any guidance would be greatly appreciated.
Thank you in advance!
I initially tried using Data Validation to create the dropdown, but it seems Data Validation doesn’t support clickable hyperlinks in this context. I’m open to alternative solutions — any guidance would be greatly appreciated.
Thank you in advance!
