hyperlink a worksheet with no address

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
Try this :
=HYPERLINK("[yourworkbookname.xls]Sheet2!A1","whatyouwantdisplyed")

Give this a go and let me know how it works
 
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)

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

Give this a go and let me know how it works
Click to expand...
 
Back
Top