I don't really understand what you're looking for, but perhaps the INDIRECT
function would be useful. Instead of =A1, use =INDIRECT("A1").


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"scottkinsey" wrote in message
...
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 ?