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
|
|||
|
|||
Maintaining link when data is sorted
I have a worksheet that links to data in a table. When the table is
sorted the links to the spreadsheet do not update for the change in location of data in the table. Any ideas how to maintain the reference to data in the table? |
#2
|
|||
|
|||
Maintaining link when data is sorted
Northland wrote:
When the table is sorted the links to the spreadsheet do not update for the change in location of data in the table. Any ideas how to maintain the reference to data in the table? Use a VLOOKUP formula instead of a direct link. 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 |
Link excel data to a visio 2002 professional shape | Darrick | Visio | 1 | August 3rd, 2004 09:09 PM |
Entering Data in a Cell While Maintaining the Formula | wiley | General Discussion | 3 | July 23rd, 2004 08:15 PM |
Countif with 2 or more data ranges in same column | Doug | Worksheet Functions | 1 | July 4th, 2004 08:57 AM |
How to create graphs in a monthly report where the base data can change | John Clarke | Charts and Charting | 3 | June 25th, 2004 02:22 AM |
Changing source data link | justin | Charts and Charting | 2 | November 6th, 2003 01:40 AM |