I have got a worksheet where column A is the date, but not in order.

Other columns have finance information, and contain calculations using data
from other cells. eg
A12=10/10/2005
B12=C25*1.175

If I now sort on column A (the date column) I find that B12 refers to some
other cell in column C, whereas I want it to take the value from where C25
has now moved to.

What am I doing wrong? (hope this makes sense)

Thanks
Rod