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