|Subject:||Re: copying value of cell to another sheet|
|Posted by:||Paul B (pbridgesne…@uga.edu)|
|Date:||Thu, 2 Oct 2003|
Sarah, try something like this, with your totals in G60
' ClearContents Macro
' Macro recorded 02/10/2003 by SARAH RANSOME
' Keyboard Shortcut: Ctrl+j
'Will put the valve in sheet1 G60 in sheet 2 column A in the next cell down
Sheet2.Range("A65536").End(xlUp).Offset(1, 0) =
Always backup your data before trying something new
Using Excel 97 & 2000
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
"Sarah" <sranso…@scouts.ca> wrote in message
> I'm hoping someone can help me...
> I have a worksheet called ENTRY
> When you enter quantities it adds up with a total sum at
> the bottom
> I created a macro to clear the quantity column so I can
> start over again.
> But I want to record the total sum on another worksheet.
> When i do it now it just replaces the info in the same
> cell - I want it to enter the next value into the next
> Any help appreciated.
> It would also be nice to have the same macro do both -
> copy the value, then clear the contents...
> Here is the macro
> Sub ClearContents()
> ' ClearContents Macro
> ' Macro recorded 02/10/2003 by SARAH RANSOME
> ' Keyboard Shortcut: Ctrl+j
> End Sub
copying value of cell to another sheet posted by Sarah on Thu, 2 Oct 2003