Mark,
Use the INSERT ROW feature just above the last
line of the table each time you want to add a new value.
This will push down the final/running total AND because
the pointers in the formulae are relative, all formulae will
adjust and adapt.
.----- Original Message -----
From: "Mark Rode" <[log in to unmask]>
> I am trying to set up two columns in Excel 2000 to calculate a running
balance.
>
> Say you have Column A and column B.
> You input a figure in cell A2 which is automatically subtracted from B1
and
> then the result is outputted to B2 and this continues down the entire
> column....input in A3 which is subtracted from B2 and inputted to B3 etc.
>
> I would also like to output the result (running balance) to a single cell
> at the top of the worksheet so I can always see the balance when i open it
> ...Say C1.
> I assume this can all be done with a formula in the B column but how do
> this so that it keeps running down the column ?
>
> thanks
> Mark Rode
>
> Curious about the people moderating your
> messages? Visit our staff web site:
> http://nospin.com/pc/staff.html
>
Do you want to signoff PCSOFT or just change to
Digest mode - visit our web site:
http://nospin.com/pc/pcsoft.html
|