Paste hyperlink to a hyperlink in another sheet

Originally Posted by skiman123321

I have a hyperlink to an external document on sheet 1. I want to use the past link function to link the hyperlink on sheet 1 to a cell in sheet 2. I select the paste special option / all formats / and paste link but the actual hyperlink to sheet 1 is not pasted into the cell on sheet 2. Only the "words" in the hyperlink are pasted.

Is there a way to paste a hyperlink in a sheet (that will be updated when the hyperlink is updated) to another sheet in the workbook?

Thanks for any help.

Hi,

No,

but you can use

=HYPERLINK(Sheet1!A1)

hth
---