I am trying to sort a column of formulas that consist of cell
references. Example:

Column:
Cell 1 holds: =D10
Cell 2 holds: =D11
Cell 3 holds: =D12

Data:
D10=1
D11=2
D12=3

When I try to sort the column of formulas, the formulas change cell
references to other cells and mess up the data.

How can I sort a column of cells of which all of them contain formulas
and have the cells keep the references to the right place?


---
Message posted from http://www.ExcelForum.com/