linking cells to carry forward a hyperlink

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I am setting up an excel spreadsheet with internally linked cells. Some of
the original cells contain hyperlinks. How do I create a link so that the new
cell not only contains the content of the original cell, but the new
hyperlink as well (at the moment, it contains the content of the original
cell (the actual words) but will not carry a URL?

Thanks
 
If your hyperlink is in cell A1, then in any other cell enter:

=HYPERLINK(A1)

to bring this link forward
 
Thanks--one more question--what is the formula if the original cell is in
another worksheet (say the worksheet is called "intro")? Thanks again
 
Back
Top