Referencing Hyperlinks Using Formulas
Posted by Harley on February 13, 2002 12:40 PM
Worksheet 1 titled "Joe" and Worksheet 2 titled "Mary".
In worksheet "Joe", cell B1, I have created a hyperlink to a webpage using the =HYPERLINK function.
In worksheet "Mary", cell A1, I have the formula =Joe!B1, which effectively copies "Joe cell B1" and places it in "Mary cell A1."
I can get that part to work but I can't get it to copy the actual hyperlink, it's not clickable when it copies into "Mary". Is there a way to get this to work?