You need to save before you reset all the money values to 0:


Hi-light the row (or column) that contains the totals. Pull-down:
Edit Copy

Go to the new worksheet, click on a cell and then pull-down
Edit Paste Special and check values. This will save your old sums.
Only then go back to the old sheet and reset the monies.
--
Gary's Student


"Mike" wrote:

Hi i have a worksheet that i use for racing data, after each race i reset
all the money values to 0, but the total one i would like to copy to a new
worksheet so when i do a reset the copied total remain, so that during a
night i know the total money taken

Thanks