Copying Hyperlinks

[tony68]

Hi Have set a hyperlink on cell A23 in sheet one that when I click it takes me to a corresponding record in sheet two which resides in cell A2. What I want to do is just drag and copy the hyperlink in cell A23 down the rest of the column so that it increases the reference cell in sheet two accordingly i.e drag hyperlink to sheet 1 A24 and when you select it takes you to sheet 2 A3 - hopefully makes sense. Is this possible?

 

[Yongle]

Try this formula in cell A23 in sheet1

=HYPERLINK("#Sheet2!"&ADDRESS(ROW(A2),COLUMN(A2)), "friendly name for " &ADDRESS(ROW(A2),COLUMN(A2),4))

 

[tony68]

Thanks that did exactly what I needed