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
Bookmarks