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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

reduce a balance from severel cells 1
hyperlink to website and then to information in a certain cell 16
Excel Monthly Spread sheet. 12
Hyperlink to cell within a sheet breaks when cells are sorted 1
Excel Hyper Links 1
COUNT rows on external sheet if between date range 3
formula question 1
hyperlink that are relavant to a work book not a computer 4

Back
Top