View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Musette Musette is offline
external usenet poster
 
Posts: 11
Default How can I make a Hyperlink to a cell within another worksheet

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