R

#### RedHead 1

referenced these cells in formulas in sheet 2. Every time I sort, the

formula does not follow the cell.

I SWEAR that I have been able to sort before without messing up my formula

references. Am I crazy? (I rarely use the computer I am working on...is it

just this version of Excel or something?)

In case you don't understand what I mean, here is an example:

Step 1- I would like Sheet2 A1 to equal the same value as Sheet1 A2. The

value of Sheet1 A2 is 262.

Step 2- In Sheet2 A1, I enter "=Sheet1!A2". It shows the value as 262.

Step 3- I want to sort Sheet1. I sort them.

Step 4- The formula is Sheet2 A1 does not follow the cell with the value of

262 (for this example, lets say that value moves from cell A2 to cell A5.

Instead, it stays stuck on cell A2, which messes up my formulas on Sheet2

because they now reference the wrong value.

Isn't there a way to sort without messing up all the values??

Hope I haven't confused everyone