Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting a linked list
I would like to be able to sort a set of rows and its linked list. For
example: A B C ... 1 1 MsgProcessor 450 2 2 DisplayMgr 500 3 3 UserPrefs 327 4 4 TestSim 402 5 6 Change Description 7 1 Need to change MsgProcessor .... 8 2 Update display with new data 9 3 Insert new user preference 10 4 Rerun test simulator I am hoping there is a way to sort rows 1-4 by col B, and then sort rows 7-10. But the numbers in col A of rows 7-10 get mixed up. For instance, A7 contains '=A1', so when I sort rows 1-4 the number changes, and then the cells do not match. I've tried absolute and relative references, but nothing has worked. Any ideas ? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting linked worksheets | Excel Discussion (Misc queries) | |||
sorting data linked to another workbook | Excel Discussion (Misc queries) | |||
Re-sorting linked data cells | Excel Discussion (Misc queries) | |||
sorting with linked worksheets | Excel Discussion (Misc queries) | |||
Trouble sorting linked worksheet - need help | Excel Discussion (Misc queries) |