Page 1, Cell A1 contains text with a hyperlink.
Somewhere on page 2 I want a cell that reflects both the text AND the hyperlink.
If the link on Page 1, Cell A1 changes, it will automatically update on Page 2.
My project actually includes about 75-100 hyperlinks on Page 1, and 20 or so other pages, each of which will refer to any number of the links on page 1.
Can I do this?
Yes, you can, though you’ll need to actually define your own formula since none in Excel really return this kind of data. If you have never defined your own before, it’s pretty easy and can really open up a whole world of possibilities if you can handle the VB portion of Excel.
To set up your formula to work, follow the example on this page.
If, on sheet 2, you then want to have one cell that returns both the value of the link and the hyperlink itself, you’d do something like this in cell A1 of sheet 2.
=CONCATENATE(Sheet1!A1," - ",(GETADDRESS(Sheet1!A1)))