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 |
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 |
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 |
All times are GMT +1. The time now is 08:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com