I have a worksheet that I sort one way for data entry and another way for
printing. In the spreadsheet, I have a column that I update every two weeks.
The column has a total; but below it, there is another formula that takes
the total and subtracts the various cells above that are not eligible. When
I go to sort it for printing, the formula's value changes. How do I get the
various cells listed in the formula to change when I sort? i.e. the cell is
X3 when I'm doing my data entry and verifying totals, but when I sort it for
printing, it is now X9 and the formula is still looking at cell X3.
--
Michele