linking cells to carry forward a hyperlink

B

Beverley

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
 
G

Gary''s Student

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

=HYPERLINK(A1)

to bring this link forward
 
B

Beverley

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