The fist cell i want to look at is G23 then G65

"stew" wrote:

Hi

=HYPERLINK(LEFT(CELL("Filename",A1),SEARCH("[",CELL("filename",A1))-25))&"road managers package\tour managers spreadsheet.xls"

Gets me to tour managers spread sheet. What and how would I add to locate a
certain cell on that spread sheet using the row() ,5, that the above formula
is in. If I drag the cell down 1 I would like it to reflect a 42 row jump.
The data held in this cell repeats itself every 42 rows.

Thanks for looking

Stew