You would need to pick a spot to go to on Sheet 2 but here's a couple of ways.
Use the Hyperlink function, for example, if the workbook you have open is named Book1 and you want to go to cell A1 on Sheet2, enter the following:
=HYPERLINK("[Book1]Sheet2!A1","Sheet2")
as an alternative
Right click the cell where you want to put a hyperlink and select Hyperlink from the pop-up menu.
In the Insert Hyperlink window select and complete the following:
Link to: Place in This Document
Text to display: Sheet2
Type the cell reference: A1
Or select a place in this document: Sheet2
Now click on "OK" to close the window
If you don't want to be dependent on the name of the file (because you might want to save it under another name), use the # sign:
[tt]=HYPERLINK("#Sheet2!A1","Sheet2")[/tt]
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.