G
Gre
I have a row of cells, that is arranged 'month1 budgeted' 'month1 actual'
'month2 budgeted' 'month2 actual' etc, for 12 months. The budgeted figures
are entered at the start of the year, and then the actual figures on a
monthly basis.
What I want to do is compare the cumulative actual spending to date, with
the budgeted figure to date.
Therefore, when Month1's actual figures are entered, I wish to have a sell
that gives me the total budgeted to date. And update automatically when
month2's, month3's,... figures are entered.
Any help would be greatly appreciated.
'month2 budgeted' 'month2 actual' etc, for 12 months. The budgeted figures
are entered at the start of the year, and then the actual figures on a
monthly basis.
What I want to do is compare the cumulative actual spending to date, with
the budgeted figure to date.
Therefore, when Month1's actual figures are entered, I wish to have a sell
that gives me the total budgeted to date. And update automatically when
month2's, month3's,... figures are entered.
Any help would be greatly appreciated.