+ Reply to Thread
Results 1 to 1 of 1

Recording results in new record

  1. #1
    Registered User
    Join Date
    03-07-2012
    Location
    Mexico City, MX
    MS-Off Ver
    Excel 2010
    Posts
    9

    Recording results in new record

    Excel for Mac 2011
    In the attached spreadsheet on SHEET 3 I have a system of tracking wins and losses. The user clicks the "Win" and "Lose" buttons to track results. Then the user clicks the "Update Amount" button which copies the SUM from B18 and adds it to the AMOUNT in J2, keeping a running total of results. The user then uses the "Reset Trade" button to restore the Win and Lose buttons to READY and repeats the process.

    What I need instead of the accumulating amount in J2 (that I currently have) is to do the following:

    When the "Update Amount" button is clicked, the SUM contained in B18 needs to be copied to a NEW RECORD in column J so that I end up with a column containing the results of every use in chronological order. Just can't figure out how to do it. Thanks
    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. Excel 2007 : Record Macro not recording...
    By gblackiv in forum Excel General
    Replies: 1
    Last Post: 10-22-2008, 01:19 PM
  2. Replies: 2
    Last Post: 10-28-2007, 02:35 PM
  3. Recording macros....record cursor movement not cell address?
    By tim m in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-22-2006, 03:35 PM
  4. Record recording
    By cdixon in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 11-20-2005, 09:30 PM
  5. [SOLVED] recording the date when record was entered in cell in Excel
    By mcgoo in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-10-2005, 07:06 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1