Hi,
Wonder if anyone can help?
I'm trying to refine a results system for a type of motorsport event called motorkhana.
A timing beam system automatically inserts the competitor's elapsed time over a "test", however officials need to manually add any penalties to the system. A separate results spreadsheet calculates the overall event results.
It's all working well, however we do occasionally experience the odd 1004 error and I'd like to improve the way the penalties are applied.
I'd particularly like to be able to click multiple buttons in the "penalties" sheet and the penalty codes be concatenated into the "penalty" cell. Currently there are buttons for most of the penalty combinations. For example I'd like to have just one "Flag" button and officials would hit it 3 times to apply a 3 flag penalty.
What I've done so far is here:
https://www.dropbox.com/s/eh18ozh08fvuf34/Area_A-Test.xlsm?dl=0
Password "Mini123"
Cheers,
Dave
Wonder if anyone can help?
I'm trying to refine a results system for a type of motorsport event called motorkhana.
A timing beam system automatically inserts the competitor's elapsed time over a "test", however officials need to manually add any penalties to the system. A separate results spreadsheet calculates the overall event results.
It's all working well, however we do occasionally experience the odd 1004 error and I'd like to improve the way the penalties are applied.
I'd particularly like to be able to click multiple buttons in the "penalties" sheet and the penalty codes be concatenated into the "penalty" cell. Currently there are buttons for most of the penalty combinations. For example I'd like to have just one "Flag" button and officials would hit it 3 times to apply a 3 flag penalty.
What I've done so far is here:
https://www.dropbox.com/s/eh18ozh08fvuf34/Area_A-Test.xlsm?dl=0
Password "Mini123"
Cheers,
Dave