I have several offices that I track sales numbers for. Those sales
results are used in other formulas for the same offices on my
spreadsheet. When I sort though, the formulas then jumble.

I may want to sort the orginal list of offices with the original sales
amount OR
I may want to sort the lists linked to the orginal sales amount


Example:
Office Sales
Arkansas 28000
Oklahoma 30000

Office Allowed Expenses
Arkansas =Sales X .25
Oklahoma = Sales X .25

How do I keep the sales number from changing if I sort either list?

Thanks


--
dianepcs
------------------------------------------------------------------------
dianepcs's Profile: http://www.excelforum.com/member.php...o&userid=25238
View this thread: http://www.excelforum.com/showthread...hreadid=387262