credit debit account calculation in a dynamic sheet

[smarty09]

hello frnds
i am new to excel n i m using office 2010
plz can u help me in creating a debit credit sheet with dynamic functions
step up step, cause i only know to fill the data in the sheets and nothing else.

i have details of columns as follows with every column having a label
A B C D E
1) details date credit debit balance
2) brought forward 12/5/08 40000
3) shopping 13/5/08 500 39500
4) interest 18/5/08 40 39540
...........
............. so on
and at the end last row shuld contain total of credit n debit. n balance carried from above row
for eg in this case last row will look like
5) 40 500 39540

i dont want to write function for every row, adding the two cells or subtracting them
i wan it to be dynamic as i dont know how many rows will be there
it should add C and subtract D from E as soon as a entry is filled in A
and By default the value of Credit n debit should be zero(not blank as it is now).

please help me step by step, as i have never created a functions sheet before.

Thanks in advance

 

[VoG]

You could try a ready-made template like this one http://office.microsoft.com/en-us/templates/CT010144112.aspx?AxInstalled=1&c=0#ai:TC030006950| or another one from this selection http://office.microsoft.com/en-us/templates/CT010144112.aspx

 

[AlphaFrog]

Here's a good step-by-step guide with and example workbook. It's not exactly what you want, but you should be able to change it to suit.
Worksheet design for tracking your account

Also, if to do a web search for something like Excel Checking Account Template or Excel Account Ledger Template, you will get several nice examples to work from.

 

[smarty09]

thanks alot, i never expected such a quick response.

 

[smarty09]

Here's a good step-by-step guide with and example workbook. It's not exactly what you want, but you should be able to change it to suit.
Worksheet design for tracking your account

Also, if to do a web search for something like Excel Checking Account Template or Excel Account Ledger Template, you will get several nice examples to work from.

thanks to both of you for ur reply
my problem is solved by ur help
are there anything as such closing the thread, so that i can do that, as both of u have solved my prob

 

[VoG]

You are welcome.

There is no facility here to mark threads as resolved.