hyperlink formula

K

kimare

=HYPERLINK("#a123"; "Next week")

The first week is placed on a123, then the second 41 rows under at
a164, and then third further 41 rows down at 205. Is there a formula I
could use in this case.
 
D

David McRitchie

=HYPERLINK("#" & ADDRESS(ROW()+41,1,4),"next week")

Will allow you to put the formula on any cell in the row ,
the link will take you 41 rows below and to the first column.
--
 
Top