If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
I am trying to link based on a text value instead of cell position
I am trying to link from one workbook to another.
The source position changes, for example product 121.1 might be one cell lower because a product 120.1 was added. So how do I paste a link based on a value instead of a cell position? Thank you for any information John |
#2
|
|||
|
|||
Hi
you may try using VLOOKUP. See: http://www.contextures.com/xlFunctions02.html -- Regards Frank Kabel Frankfurt, Germany "John" schrieb im Newsbeitrag ... I am trying to link from one workbook to another. The source position changes, for example product 121.1 might be one cell lower because a product 120.1 was added. So how do I paste a link based on a value instead of a cell position? Thank you for any information John |
#3
|
|||
|
|||
John wrote:
So how do I paste a link based on a value instead of a cell position? You could name the cell you want to link to (names move with cells when rows or columns are inserted or deleted; addresses don't). Or you could use a VLOOKUP formula, in which case it would be wise to name the table in which you are doing the VLOOKUP Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
#4
|
|||
|
|||
One method that I have used in this situation is to save the xcel workbook as
a web page, when you do this there is an option to auto republish whenever the work book is saved, have the publish location be your web serve and link into the individual htm files this way. There may be a way to open the page in the xls format that somebody else knows here, but this is a work around that works for me. A lot of times opening excel pages differs depending on the browser, OS, (SP2 security may block a script that opens a specific page altogether). I have also had behaviour vary depending if the excel document opens within the brower or outside. Hope this helps "Bill Manville" wrote: John wrote: So how do I paste a link based on a value instead of a cell position? You could name the cell you want to link to (names move with cells when rows or columns are inserted or deleted; addresses don't). Or you could use a VLOOKUP formula, in which case it would be wise to name the table in which you are doing the VLOOKUP Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to block text for printing that prints in the same position o. | PJP | General Discussion | 1 | September 3rd, 2004 10:32 PM |
Counting based on the occurrence of text in a cell | smilroy | Worksheet Functions | 17 | September 2nd, 2004 04:05 PM |
Too many hyperlinks? | [email protected] | Powerpoint | 7 | May 25th, 2004 02:19 AM |
Link based on Cell Value | Dave Bogot | Links and Linking | 1 | January 28th, 2004 08:19 AM |
Importing text to chart based on link to cell | Stephen | Charts and Charting | 2 | November 8th, 2003 05:07 AM |