data update

[Zulu]

Hi
I play darts and have made a spreed sheet to help with practicing
which is
pretty cool. I would like to keep an update of all input that I have
made.
My sheet works like this, I play games of 501 and the average score,
average
per dart, tons and etc will change as I play more and more games, I
have
also made a macro button that will clear all the data that I have added
BUT I
would like to keep a record on another sheet that will keep on
updating. For e.g. I have average score in D4 sheet1 I would like to
update this on shee
t 2 D4 so after I hit the macro button to clear the cell contents I
will stil
l have a record on sheet2 is this possible and if so would someone be
so kind in helping me out please.

Regards Zulu


+-------------------------------------------------------------------+
|Filename: darts (Large) (Medium).JPG |
|Download: http://www.excelforum.com/attachment.php?postid=5148 |
+-------------------------------------------------------------------+

 

[VBA Noob]

Can you post the excel sheet on the below site

http://savefile.com/

Do you need to store each result or just the running averages

VBA Noob

 

[Zulu]

Thanks for the reply I have uploaded the file

http://www.savefile.com/files/7945716

I would also like to keep as much info as possible.

Regards Zul