Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 1
Default Moving Links in Excel


Hello!

Can anyone help me figure out how to lock hyperlinks to a text instead
of to a cell? I am creating an inventory list (with List Maker) in
Office Mac 2004 Excel. I need to link the name of the product (in
Column A) to another Excel sheet with details about the product. The
links work fine, but if I add additional products, the links move with
the original cells - not with the product text they were assigned to.
I have checked 'help' and my Excel book, but cannot find any information
about locking links.

Any help would be much appreciated!

Thanks!

-Anna-Vija


--
annavija
------------------------------------------------------------------------
annavija's Profile: http://www.officehelp.in/member.php?userid=4240
View this thread: http://www.officehelp.in/showthread.php?t=1171855

Posted from - http://www.officehelp.in

  #2   Report Post  
Posted to microsoft.public.excel.links
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 Opens Excel 97 Files & recalcs links RobertD Excel Discussion (Misc queries) 4 August 18th 06 12:54 AM
can excel links be somehow relative to folder structure? Paul134 Excel Discussion (Misc queries) 0 March 2nd 06 03:22 PM
External Links on open and Excel 2003 Guardian Excel Discussion (Misc queries) 3 June 16th 05 12:25 AM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
moving excel in word back to excel Briton Excel Discussion (Misc queries) 0 January 21st 05 10:43 PM


All times are GMT +1. The time now is 12:01 AM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"