linking cells to carry forward a hyperlink
 

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

linking cells to carry forward a hyperlink
 

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

=HYPERLINK(A1)

to bring this link forward
--
Gary''s Student
gsnu200712

linking cells to carry forward a hyperlink
 

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" wrote:

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

=HYPERLINK(A1)

to bring this link forward
--
Gary''s Student
gsnu200712

linking cells to carry forward a hyperlink
 

someting like:

=HYPERLINK(intro!D14)

--
Gary''s Student
gsnu200712