K
KennyJC
I made a spreadsheet which acts as a scorekeeper for darts. One column
you put in what you score and the other colum subtracts the score down
from 501. I managed to put in a 'New Game' macro which clears this
sheet. Although I also want the newgame to save the scores to a
database and the reason for this is that I want to calculate
statistics in excel. Such as average score, number of legs played,
number of 180's, average checkout, highest checkout etc. I'd be able
to do this quite easily, but first I must figure out how to get the
scores saved into access after each game is completed in Excel.
If anyone could give me an idea how to do this or point me to some
examples or what to read up on that'd be great.
Cheers.
you put in what you score and the other colum subtracts the score down
from 501. I managed to put in a 'New Game' macro which clears this
sheet. Although I also want the newgame to save the scores to a
database and the reason for this is that I want to calculate
statistics in excel. Such as average score, number of legs played,
number of 180's, average checkout, highest checkout etc. I'd be able
to do this quite easily, but first I must figure out how to get the
scores saved into access after each game is completed in Excel.
If anyone could give me an idea how to do this or point me to some
examples or what to read up on that'd be great.
Cheers.