Excel, Help?!

Hi, I need your help urgently. See the screen shot for more lucid explanations below.

http://forums.techarena.in/attachmen...1&d=1280940710

Actually, I need to calculate the total balance of my client owned to my company. When I enter the new entry in new cell, the total balance cell has to move downwards, and the total balance is calculated automatically, when I enter the new entry in the row. It's much better for me and less time consuming. Please, reply as soon as possible.


Thanks.

Usually this is only possible by Macro. You can create a Macro for auto inserting a column in the excel sheet. Or else there is no proper fomula for that. But you can also use freeze pane to see the total always on the main page and put the amount at the below end. The free pane will divide the sheet in two section and then you can browse the same. Try to setup some Macro there.

Can you refer me to some manual?

A running balance differs from a running total (also called a running count), in which you watch the number of items in a worksheet add up as you enter new items. For more information, check out how to calculate a running total from here.