Openoffice calc\Excel query

workaccount

Hi,
I'm setting up a sheet here at the moment for managing money for something.

I have three fields on the sheet with values for current money in account, current cash and current credit card balance.

I then want to have different input fields down below where I can enter in a price for something I paid via credit card for example. When I press enter on this value I want it to automatically update the credit card balance above. So if the current credit card balance is 500 and I enter 50 down below then the new value for credit card balance should be 450.

Any ideas?

Big Lar

I dunno what way you are doing it, But if I was doing it I would:

Have a separate worksheet for each account

Have 5 columns in each worksheet; Date, Details, CR, DR & Balance

My Balance (Column E) would have the following formula in lets say row 2 =E1+C2-D2 and in the Column E row 3 would be =E2+C3-D3 and so on.

If you just insert the formula into the first cell, you can then drag it down and excel will auto adjust the formula for each cell.