Help with macro please

M

Mike

i want to save a figure from a worksheet to another worksheet before i reset
the first one has anyone got any idea how i would do it please
 
N

Nick Hodge

Mike

Bit short on detail, but if you want to copy A1 on Sheet1 to A1 on Sheet2
and then clear the original it would be

Sub ClearDataAfterCopy()
Worksheets("Sheet2").Range("A1").Value = _
Worksheets("Sheet1").Range("A1").Value
Worksheets("Sheet1").Range("A1").Clear
End Sub


--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]
 
M

Mike

Hi Nick thanks for reply, what i'm trying to do is on sheet 1 i have it set
up to run race nights and in one cell i choose the race number (1-8) once the
race starts i reset it but i want the total £ sold to remain on another
worksheet, so i can total it up at the end of the night, so basically i want
to save the figure in one cell to another, depending on race number, is it
possible please
 
Top