David McRitchie posted this and it might help you:

=HYPERLINK("#"&CELL("address",C5),C5)
=HYPERLINK("#"&CELL("address",sheetone!C5),sheeton e!C5)
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)

These formulas will adjust if you change the sheet name or insert/delete
rows/columns on the linked sheet.

stew wrote:

Dear Shane / Sheeloo

I can Hyperlink to files outside my work book, by using insert hyperlink but
I cannot link to a worksheet within my book no matter how I try to do it. I
am using excel 2003 and Vista. Is there anything else I should be doing.
If I do not hear anything from anybody I will re post with a new thread

Thanks

Stewart

"stew" wrote:

Thanks shane. I can also see the shape of how to develop this. Thanks
stew

"ShaneDevenshire" wrote:

Hi,

With a dummy file I created a hyperlink via the Insert, Hyperlink command.
Then I modified it by adding B inside the quotes and &ROW(A5) outside.

HYPERLINK("Lesson12.xls!B"&ROW(A5))

See if you can start with these ideas and get something that works.

--
Thanks,
Shane Devenshire


"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

--

Dave Peterson