Thread: How can I make a Hyperlink to a cell within another worksheet rela
View Single Post
  #1   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 rela
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.



Reply With QuoteReply With Quote