Copy contents of cell before macro clears it

Hey All, first of all. I have learned so much from everyone here and have never actually posted any questions before.. because I haven't needed to. But, today I'm stumped.

I am creating a sheet that will be used as a multiplayer score sheet for playing darts.
I have created a macro clears the "Scores" column by clicking a button after each game ends. During the scoring of each game, I have countif Eg:

Please Login or Register  to view this content.

formulas that are picking out the scores over 99, over 139 and over 179. as well as calculating averages during the game. eg:

Please Login or Register  to view this content.

What I can't figure out is how to save that counted data after I click the "reset scores" button. So I can keep a running count of how many 100+'s, and so on, or an average over a match.
Here is the Macro script I am running (I did not write this, I found it by searching ) - I should add, this script works great. I have a button at the top of each players section to clear their scores for a new game.

Please Login or Register  to view this content.

I figure an addition to this macro that copies the cell contents to another worksheet called totals and adds them up would be the best option, but again, I'm not the expert here

Any thoughts? I have attached the file if anyone is interested in using for themselves or to help figure this out

And thanks again for any help any of you can offer!!

What data would you want copied and where exactly would the data be copied to on the Totals sheet?

Try this:

Please Login or Register  to view this content.

I figured you'd want to erase the totals eventually - just put the red code in each "P" routine

Post #1 does not comply with Rule #3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Thanks.

Replace the SaveTotals routine code with:

Please Login or Register  to view this content.