Hi sheeloo

I am trying to use the Hyperlink in my first post with and addition to the
end that will allow me to link to that work sheet at that cell. This addition
has to do what you have done but how do I include that in the in the
hyperlink.

Thanks Stew

"stew" wrote:

i HAVE NOW TRIED THIS AND IT WILL NOT OPEN ON THE CELL
=HYPERLINK(LEFT(CELL("Filename",A1),SEARCH("[",CELL("filename",A1))-25))&"road
managers package\tour managers
spreadsheet.xls"&ADDRESS(6+42*ROW()-204,(COLUMN())-16)

this formula is in row 5
"stew" wrote:

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