I have made a excel sheet that works as a Spades calculator for when I play with my friends. We've wanted to start keeping a running tally of wins, nils made etc. I can make all of that, however normally whenever I finish a game I clear the input fields and reuse the sheet. So, I want a way to export the results of the game to another tab or sheet, make it static, so that when I clear the fields on the original sheet, the exported data will stay.

I was able to do this by making rows of data linked to the original sheet and then manually hitting ctrl+shift+" under each cell, but this takes a very long time.

I am using excel 2003.

Thanks!