Say you want to link to C5 on a worksheet named "Sheet two", put this in a cell:

=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)
or
=HYPERLINK("#"&CELL("address",'sheet two'!C5),"Click me")



Musette wrote:

Sorry Dave (and David)

You are dealing with a novice here. I have no idea where to put:

=HYPERLINK("#"&CELL("address",C5),C5)
=HYPERLINK("#"&CELL("address",sheetone!C5),sheeton e!C5)
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)

...or what it means.

Can you "spell it out for me"?

Thanks.

"Dave Peterson" wrote:

Use another cell in an adjacent column and use the =hyperlink() function.

David McRitchie posted this and it might help you:

=HYPERLINK("#"&CELL("address",C5),C5)
=HYPERLINK("#"&CELL("address",sheetone!C5),sheeton e!C5)
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)

Musette wrote:

I have lists in a workbook with hyperlinks to a specific cell within a
specific worksheet.

Ex: Master Sheet | Cell A3 - links to - Sheet 2| Cell A1
Sheet 2 | Cell A1 - links to Master Sheet | Cell A6

If I change any order of cells, I lose the hyperlink. How can I make it so
that if I "sorted" the rows in the Master Sheet the Sheet 2 hyperlinks will
find what was formerly Cell A6?

Hope this makes sense.

--

Dave Peterson


--

Dave Peterson