Easy to do, but I need to know if A21 changes because data is entered into it
or because it has a formula.
--
Gary''s Student - gsnu200742


"meggy" wrote:

I would like for the contents of a cell (ie: A21) to post to a cell in
another column (ie: D1). However, when the contents of A21 change I would
like for the new figure to post to the next available cell in column D (D2).
I want that process to continue in consecutive cells as the value of A21
continually changes.

Column A is a column in which I am adding figures. A21 is the sum. D would
be a record of all of those sums.