+ Reply to Thread
Results 1 to 2 of 2

cell 1 passing data to cell 2 then cell 1 reverts back to 0 while cell 2 maintains sum

  1. #1
    Registered User
    Join Date
    11-01-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    4

    cell 1 passing data to cell 2 then cell 1 reverts back to 0 while cell 2 maintains sum

    I need some help please

    I need to be able to enter data (numbers) in cell 1 and then have that data passed to cell 2 (adding to the total in cell 2)

    Then have cell 1 revert back to the value of 0 while cell 2 keeps the updated sum

    for example


    cell 1 cell 2
    0 5

    then 2 is entered into cell 1

    cell 1 cell 2
    2 7

    then have cell 1 revert back to 0 while cell 2 keeps its total

    cell 1 cell 2
    0 7


    Is there anyone that knows how to do this?

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,445

    Re: cell 1 passing data to cell 2 then cell 1 reverts back to 0 while cell 2 maintains sum

    You'd need a VBA worksheet change event monitoring cell 1 to do this.


    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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