copying value of cell to another sheet

Giganews Newsgroups
Subject: copying value of cell to another sheet
Posted by:  Sarah (sranso…@scouts.ca)
Date: Thu, 2 Oct 2003

Hi
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
cell..
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
'
    Range("G2:G59").Select
    Selection.ClearContents
End Sub

Replies