Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.links
SueD
 
Posts: n/a
Default Sorting loses links to data

In Office 2000, I have links to cells in an Excel list. When the list is
sorted, the links remain to the cell references, so show different data. I
want the links to follow the data when it is sorted, so I guess I somehow
need to link to data and not cells.
  #2   Report Post  
Posted to microsoft.public.excel.links
Bill Manville
 
Posts: n/a
Default Sorting loses links to data

Assuming that there are unique values in one of the columns of the
table that you could use to find the value you want, you need to use a
VLOOKUP formula (if the column of unique values is on the left) or a
combination of INDEX and MATCH (if it is not).

If this is not sufficient to help you, please give an example of what
the source table contains and say which value you want to access by a
formula

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

  #3   Report Post  
Posted to microsoft.public.excel.links
SueD
 
Posts: n/a
Default Sorting loses links to data

Thank you for your suggestion, but I have subsequently solved the issue by
adding a column to identify the data and then using the SUMIF formula to pick
out the required items.

"Bill Manville" wrote:

Assuming that there are unique values in one of the columns of the
table that you could use to find the value you want, you need to use a
VLOOKUP formula (if the column of unique values is on the left) or a
combination of INDEX and MATCH (if it is not).

If this is not sufficient to help you, please give an example of what
the source table contains and say which value you want to access by a
formula

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
Preserve existing data whilw using external links Hal Excel Worksheet Functions 0 April 7th 06 01:38 AM
Data from Excel 2000 Worksheet with external links is not displayed when opened in Excel 2003 Rich Rodberg Links and Linking in Excel 1 October 21st 05 07:53 AM
Sorting Data Henrik Excel Discussion (Misc queries) 0 September 29th 05 02:33 PM
Data Table - Graph Links Breaking!!! Geise, Brad Charts and Charting in Excel 1 March 31st 05 12:34 AM
I want a window to cell data that conains links to PDF files and . WEATHER TECH. NOT A ROCKET ENGINEER Excel Discussion (Misc queries) 1 February 24th 05 09:21 PM


All times are GMT +1. The time now is 09:32 PM.

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

About Us

"It's about Microsoft Excel"