Excel Sheet Calculating Monthly Interest

[aquif]

Dear All, I have attached a snapshot of my excel sheet for calculating Monthly interest. In this sheet i enter monthly Purchase and payment in Column B and C. and the sheet calculates my average monthly balance and then interest for the month. However at the end of every month i have to reset

1) Beginning balance in D2 which now will be the sum of Either of Cell D31, D32, D33 or D34 (Depending on number of days in the month current month) And Cell D48 which is the interest factor. and

2) Manually remove all the Purchase and payment Data in Column B and C.

I was wondering if both steps 1 and 2 which i do manually can be done through some excel formulas or through Macros? It can save a lot of time for me. Am a newbie with excel so dont know much about it.

[oeldere]

You get better help, if you follow the advice in the link below.

http://www.excelforum.com/the-water-...-question.html

Please also add the (desired) result in you sheet.

[aquif]

I have attached the excel file and also mentioned desired results

[oeldere]

Maybe like this (every month an new sheet).

See the attached file.