Scoreboard Help

[TDWDarts]

I have developed a darts scoreboard which allows me to, in a basic way, enter scores in certain boxes and reduce the overall score until it reaches 0.

Along the way, certain stats are collected and displayed, both from within the current game and the overall match.

I have a button which allows a new game to be set up (resets game stats) and a new match (resets game and match stats).

I want to be able to add a bit of code to my new game button, which basically looks to see if the current game has been finished, and if it hasn't then it resets the stats to what they were at the start of the game.

This is currently the piece of code which works fine in terms of collecting the scores and reporting on them:

Please Login or Register  to view this content.

Essentially what this does is looks at the score entered in the field higher up and copies it into the next appropriate cell in column E or Q. If a player reaches 0, then the checkout (i.e. their final score that made the game finish is also copied into columns F or R. From this, I can then work out all the stats.

How would I go about adding a bit of code that essentially looks to see if the game is in progress and if so only deletes the scores relevant for that particular game?

Hope this makes sense, but I can upload the spreadsheet somewhere if required.

[sourabhg98]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[TDWDarts]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Thanks. I would if my hard drive hadn't just packed in! Will try and recover things and upload stuff here.