=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.
--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm
"kimare" wrote in message ...
=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.
--
kimare
------------------------------------------------------------------------
kimare's Profile: http://www.excelforum.com/member.php...o&userid=16501
View this thread: http://www.excelforum.com/showthread...hreadid=320384