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