|Subject:||copying value of cell to another sheet|
|Posted by:||Sarah (sranso…@scouts.ca)|
|Date:||Thu, 2 Oct 2003|
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
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
' ClearContents Macro
' Macro recorded 02/10/2003 by SARAH RANSOME
' Keyboard Shortcut: Ctrl+j