linking cells to carry forward a hyperlink

[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

 

[Gary''s Student]

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

=HYPERLINK(A1)

to bring this link forward

 

[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

 

[Gary''s Student]

someting like:

=HYPERLINK(intro!D14)