dynamic hyperlink

[leecavturbo]

well when i say dynamic. I have a hyperlink ( link ? ) in sheet 2 to a cell in sheet 1. but what i need is when i copy that sheet to make another ( with tab, copy move to end ) is for the link to reference sheet 1 but 1 row lower than the last.
possible without vba ?

 

[FormR]

Hi, you can use a "#" symbol in the hyperlink function to refer to the workbook that contains the formula - so assuming post 20 works, this should also.

=HYPERLINK("#'Sheet1'!$A"&2+SHEET(),"My Link")

 

[Legacy 143009]

Hi, you can use a "#" symbol in the hyperlink function to refer to the workbook that contains the formula - so assuming post 20 works, this should also.

=HYPERLINK("#'Sheet1'!$A"&2+SHEET(),"My Link")

Waaa