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

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
HIS


"Mike" wrote in message
...
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

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

"Nick Hodge" wrote:

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
HIS


"Mike" wrote in message
...
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

Mike

I still find it difficult to imagine the structure of the sheets. If you
want to send it to me, I'll take a look

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Mike" wrote in message
...
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

"Nick Hodge" wrote:

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
HIS


"Mike" wrote in message
...
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