M
Megan
I'm having a difficult time with maintaining my formulas
when I sort. I have several formulas within column D.
Some cells simply refer to the value in another cell
within the same column and others actually hold a formula
such as "=$D$5*1.1". My problem comes when I try to sort
the worksheet by the data in column C...all of the
formulas mean nothing because the point to the absolute
cell...but if I don't use absolutes, I end up with
circular references.
How do I attach the formula to the DATA location instead
of the CELL location?
Thanks!
when I sort. I have several formulas within column D.
Some cells simply refer to the value in another cell
within the same column and others actually hold a formula
such as "=$D$5*1.1". My problem comes when I try to sort
the worksheet by the data in column C...all of the
formulas mean nothing because the point to the absolute
cell...but if I don't use absolutes, I end up with
circular references.
How do I attach the formula to the DATA location instead
of the CELL location?
Thanks!