Results 1 to 4 of 4

Thread: Excel, Help?!

  1. #1
    Join Date
    Jul 2010
    Posts
    37

    Excel, Help?!

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



    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.
    Attached Images Attached Images
    Last edited by alex198555; 04-08-2010 at 10:26 PM.

  2. #2
    Join Date
    Nov 2009
    Posts
    351

    Re: Excel, Help?!

    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.

  3. #3
    Join Date
    Jul 2010
    Posts
    37

    Re: Excel, Help?!

    Can you refer me to some manual?

  4. #4
    Join Date
    Dec 2007
    Posts
    2,291

    Re: Excel, Help?!

    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.

Similar Threads

  1. Replies: 6
    Last Post: 17-02-2012, 01:18 PM
  2. Cell format errors appears in Excel 2003 but not in Excel 2000
    By @nki$achi in forum MS Office Support
    Replies: 1
    Last Post: 24-01-2012, 05:00 PM
  3. Excel 2007 file fails to get permission to open in Excel 2011
    By Raju Chacha in forum Windows Software
    Replies: 6
    Last Post: 13-01-2012, 09:17 PM
  4. Replies: 6
    Last Post: 17-05-2011, 10:00 PM
  5. Replies: 4
    Last Post: 13-02-2011, 10:37 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,662,566.03018 seconds with 17 queries