I am interested in creating a Data Validation drop down menu that contains report names (text) with an embedded hyperlink.
The way I'm doing this now is creating a table on another sheet, listing all the reports (Report 1, Report 2, etc) within that table, and then embedding hyperlinks on all those report names. Then, on another sheet, I'm creating the drop down menu through Data Validation that sources those report names.
Right now, the drop down menu appears, and I can choose the reports, but the embedded hyperlinks don't carry over.
Is there a way to do this? I've found some answers online that suggest workarounds using HYPERLINK pointers, but this isn't what I want to do. Any help appreciated, thanks!