hyperlink a worksheet with no address

[Guest]

How do i create a hyperlink from one worksheet to another within the same
workbook but so the location of the file itself will not cause an error in
the link.
When i create a hyperlink, then it has the address: "c:\document and ..."
how do i create it without?

 

[Steel Monkey]

Try this :
=HYPERLINK("[yourworkbookname.xls]Sheet2!A1","whatyouwantdisplyed")

Give this a go and let me know how it works

 

[Dave Peterson]

David McRitchie posted this and it might help you:

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

Try this :
=HYPERLINK("[yourworkbookname.xls]Sheet2!A1","whatyouwantdisplyed")

Give this a go and let me know how it works