Hi

I have a cell, D3, that sums up a day's change in other cells, rows etc, and would like to chart the development of D3's daily changes, probably as presented by a nearby column (or row) - without having to type/copy the different values by hand, one by one down the column.
The question is: How does one make a simultaneously progressing column, for example from E4 and infinetely downwards, with a new cell filled for each change in D3 (Day 2 turns up in E5, Day 3 in E6, etc)?
Any macro solution is no option, I'm afraid. The solution, I reckon, would be some kind of formula to be copied and swept down the E column.
That formula I should really like to see.
Hope someone knows it.

Thanks in advance
BCB