software

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

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 gt; Copy

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

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

are you doing this with a macro

Sub Reset()
With Worksheets(quot;Summaryquot;)
set rng = .Cells(rows.count,1).End(xlup).offset(1,0)
End with
rng.Value = Date
with Worksheets(quot;Dailyquot;)
rng.Offset(0,1).Value = .Range(quot;B30quot;).Value
.Columns(2).SpecialCells(xlConstants,xlNumbers).Va lue = 0
End with

end sub

--
Regards,
Tom Ogilvyquot;Mikequot; wrote:

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