hyperlink formula
=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 |
All times are GMT +1. The time now is 04:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com