Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I get Excel to automatically change file path links? | Excel Discussion (Misc queries) | |||
Can multiple spreadsheets be linked to change simultaneously? | Excel Discussion (Misc queries) | |||
How can I delete source links and change the current sheet accord. | Excel Worksheet Functions | |||
Edit Links: make update manual | Excel Discussion (Misc queries) | |||
compare two spreadsheets and identify records that have any change | Excel Discussion (Misc queries) |