+ Reply to Thread
Results 1 to 2 of 2

Macro For Accumulated Numbers After I Erase Data in Other Cells

  1. #1
    Registered User
    Join Date
    11-23-2018
    Location
    Alberta
    MS-Off Ver
    2013
    Posts
    23

    Macro For Accumulated Numbers After I Erase Data in Other Cells

    Hello,

    I am looking for a macro for tracking accumulated numbers. My question is, say in column B1-B10 I have text about the number I am tracking, In cell C1-C10 I have the actual number for that day. Cell D1-D10 will accumulate the data entered in cells C1-C10. I want to know what the macro/vba or formula I could use so that when I erase the number from C1-C10 daily the accumulative cells (D1-D10) will stay the same, and then grow when I enter new data in cell C1-C10 each day. Any help on this would be greatly appreciated.

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,680

    Re: Macro For Accumulated Numbers After I Erase Data in Other Cells

    Copy the below code and do right click on sheet tab and select view code and paste it.

    Close the VBA window (Alt+Q to close VBA window) and return to that sheet and check.

    Please Login or Register  to view this content.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

+ 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: 8
    Last Post: 09-09-2019, 10:10 PM
  2. Help: multi function macro needed - copy row, reset checkboxes, erase cells.
    By Acubed in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-29-2014, 09:37 AM
  3. VB Code to erase two cells as data changes in another
    By Nitefox in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 09-30-2013, 12:28 AM
  4. Replies: 8
    Last Post: 02-27-2013, 05:36 PM
  5. [SOLVED] Macro to Erase Data
    By Taislin in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-13-2012, 04:05 PM
  6. Excel 2007 : macro help to erase data from a worksheet
    By khanaran in forum Excel General
    Replies: 3
    Last Post: 07-01-2012, 04:31 AM
  7. macro that would erase part of data in a cell?
    By tradewindrider in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-17-2007, 02:09 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