Hyperlinks within worksheets

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

Guest

How do I create a hyperlink from one place to another within a worksheet so
that when the worksheet is copied, the hyperlink references to the copied
worksheet and not the original sheet. (Excel 2003)
Thanks
 
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)
 

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

Hyperlinks stopped working 4
Hyplinking Question 2
HYPERLINK Worksheet Function 3
Excel Macro to hyperlink an archived worksheet to an index page 0
How to return to the previous active sheet after hyperlink? 5
Hyperlinks in Excel 2007 1
Hyperlinks 2
Linking item between two worksheets 1

Back
Top