Hyper link between spread sheets

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

Hi,
I have an excel file with a number of different work sheets say, wksheet1,
wksheet2 and wksheet3.
Is it possible to use the hyperlink function to switch between work sheets?
For example, if I'm on wksheet1 and want to switch to wksheet2 can I click
on a hyperlink which is written as wksheet2 to switch to wksheet2.

Thanking you in advance.
 
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)
 
Back
Top