help please

[Guest]

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

 

[Guest]

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.

 

[Guest]

are you doing this with a macro

Sub Reset()
With Worksheets("Summary")
set rng = .Cells(rows.count,1).End(xlup).offset(1,0)
End with
rng.Value = Date
with Worksheets("Daily")
rng.Offset(0,1).Value = .Range("B30").Value
.Columns(2).SpecialCells(xlConstants,xlNumbers).Value = 0
End with

end sub