View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.links
Bill Manville Bill Manville is offline
external usenet poster
Posts: 473
Default Moving Links in Excel

I'm not a Mac user, so forgive me if this advice is inappropriate.
I would use the HYPERLINK worksheet function.
To link to cell Z3 on sheet Sheet2, with text "Product A":

=HYPERLINK(CELL("address",Sheet2!$Z$3),"Product A")

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup