I have a excel file with 2 worksheets.
The first worksheet is a list of hyperlinks to files (with a "friendly"
display name).
I want to create a cell in the second worksheet which uses data validation
to pick from the list of hyperlinks. I want the hyperlink on the second page
to be active so that users can click on it and go to the file. I also want
only the user "friendly" name to appear in the cell.
So far when I use data validation the link does not work and only the
"friendly" name appears as regular text in the cell.
Help!