+ Reply to Thread
Results 1 to 1 of 1

VBA or formula to add up as numbers are entered/changed

  1. #1
    Registered User
    Join Date
    05-29-2010
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    58

    VBA or formula to add up as numbers are entered/changed

    This might be a formula or a macro/VBA - I have a feeling it will be VBA.

    I have 5 columns in a sheet; B, E, H, K and N. These cells will be changed every so often. They will contain numbers.
    So for example cells B3 could contain number 20 and then a few weeks later be changed to number 40. The running total would be 60.

    I would like a formula/macro/VBA code that will add the figures to the overall total every time the figure in B, E, H, K or N.

    So for example B3 is 20 then it is changed to 40, the total would be 60.
    Then cell E3 is changed to 30, so the running total is 90.
    Then B3 is changed again to 60, so the running total is 150 and so on.

    I am happy for this to be one code or formula that calculates all cells, or for it to be 5 different codes; one for each cell. This will be over 10,000 rows, so it will need to either work on all rows in the sheet, or allow copying to all rows.

    An example is attached and I would appreciate any help.

    Thanks in advance.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 11
    Last Post: 07-15-2012, 08:44 PM
  2. Cell format when value entered or changed
    By ferdinyo in forum Excel General
    Replies: 2
    Last Post: 05-10-2012, 11:35 AM
  3. Cell format when value entered or changed
    By ferdinyo in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 05-10-2012, 10:43 AM
  4. Replies: 0
    Last Post: 12-13-2011, 05:13 PM
  5. numbers being entered show in formula bar but not in cell?
    By Jim in Florida in forum Excel General
    Replies: 2
    Last Post: 05-13-2005, 02:06 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1