Hi Guys,

I have an excel spreadsheet which basically has columns of money coming in and money going out, and is in chronological order such that Left --> Right is Oldest --> Newest.
I have 3 rows; Money In, Money Out, and Balance.
The last row simply takes the balance from the previous date, add's "Money in" to it and subtracts the "Money out".

The problem I am having is that if I insert a new column (i.e. a new date entry sandwiched in between two existing date entries), the "balance" cell changes so that it refers to the same cell it was referring to before - i.e. it refers to the cell which is two columns to the left, after inserting the new column. I want to get it so that it always refers to one column to the left, even if a new column is inserted.

Any tips on how to do this?

Help will be much appreciated!

Thanks
Sunny.