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? |
All times are GMT +1. The time now is 03:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com