Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
help please
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
help please
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
help please
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).Va lue = 0 End with end sub -- Regards, Tom Ogilvy "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|