copying value of cell to another sheet

Giganews Newsgroups
Subject: copying value of cell to another sheet
Posted by:  Sarah (sranso…
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
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