Hello!
Can anyone help me figure out how to lock hyperlinks to a text instea
of to a cell? I am creating an inventory list (with List Maker) i
Office Mac 2004 Excel. I need to link the name of the product (i
Column A) to another Excel sheet with details about the product. Th
links work fine, but if I add additional products, the links move wit
the original cells - not with the product text they were assigned to.
I have checked 'help' and my Excel book, but cannot find any informatio
about locking links.
Any help would be much appreciated!
Thanks!
-Anna-Vij
--
annavij
Posted from - http://www.officehelp.i
Bill Manville - 19 Aug 2006 08:34 GMT
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