Thread: How make hyperlink refer to cell content rather than cell address.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Omunene
 
Posts: n/a
Default How make hyperlink refer to cell content rather than cell address.
An Excel spreadsheet with names in Column A.
"Bush, George" is in cell A75.
"Dubya" is in cell A125.
I want a hyperlink from "Dubya" to "Bush, George."
If I add or delete rows above "Bush, George," I want the hyperlink to follow
the name, not just keep pointing to call A75.

Help? (Thanks!)
Reply With QuoteReply With Quote