linking cells to carry forward a hyperlink

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Beverley - 28 Mar 2007 02:50 GMT

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

Reply to this Message

Gary''s Student - 28 Mar 2007 10:30 GMT

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

=HYPERLINK(A1)

to bring this link forward

Signature

Gary''s Student
gsnu200712

Reply to this Message

Beverley - 28 Mar 2007 11:02 GMT

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

> If your hyperlink is in cell A1, then in any other cell enter:
>
> =HYPERLINK(A1)
>
> to bring this link forward

Reply to this Message

Gary''s Student - 28 Mar 2007 13:40 GMT

someting like:

=HYPERLINK(intro!D14)

Signature

Gary''s Student
gsnu200712

Reply to this Message