View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Russell-stanely Russell-stanely is offline
external usenet poster
 
Posts: 4
Default Change links between 2 spreadsheets

I have a master list of unsorted items and then a 2nd spreadsheet where cells
are linked (relative) to the master list.
I want to sort the master list alphabetically, but this causes the 2nd
spreadsheet info to change (hold the incorrect value) as the alphbetical sort
moved the info to another cell.

How can I make it so that the info on the 2nd spreadsheet "follows" the sort
on the master list so that the info remains correct?