Thread: Hyperlink to Cell in a Seperate Worksheet

Hi All,
I am reasonably new to excel and have a question I thought you may be able to help with.....

I would like to create a hyperlink on a cell that links to that cells value in a seperate worksheet. ie: Worksheet A, Cell A1=A12345 --- Hyperlink to Find value A12345 in worksheet b. Can this be done?

Thanks in Advance

This example creates a hyperlink to
To: cell C10
On: the sheet named MySheet
In: the current workbook

A1: Click Me
B1: (the sheet and cell location to link to___eg MySheet!C10)

This formula creates the hyperlink
C1: HYPERLINK("#"&B1,A1)

Note the hash mark (#) before the sheet name

Alternatively, you could use the Excel Main Menu:
• Select the cell to contain the hyperlink
• Insert.Hyperlink
• Click: Place in this document
...Complete the appropriate fields (Text to display, cell ref, etc)

Or...to build a link to a cell in the worksheet containing it (even if copied)

• Select the cell to contain the hyperlink
• Insert.Hyperlink
• Click: Existing file or webpage
• Address: #A1
• Click: OK

Does that help?