Update vaules only with Macro

Tech-Archive recommends: Fix windows errors by optimizing your registry

I have a source *** ( which will change often) and a data entry *** will
will be updated almost everyday. When the source *** changes it will change
vaules in the data entry ***.
I want to extract the vaules only out of the data entry *** every time it
is updated into a main archive *** in a user friendly way.
All sheets staying in the same workbook.
I recorded a macro to copy and paste the same rows and columns out of the
data entry *** and into the archive ***. But the vaules paste into the
same location everytime.
I want the user to click into a row of their choice (next empty one) and
click on a macro button to paste all new vaules into the archive.
What do I need to change in this macro to make it work ..
Thanks,
Barb


Sub Copyandpaste()
'
' Copyandpaste Macro
' Macro recorded 7/29/2005 by BSchwarz
'
' Keyboard Shortcut: Ctrl+Shift+C
'
Range("A2:M395").Select
Selection.Copy
Sheets("KanbanOrders").Select
Range("A2").Select
Active***.Paste
Range("N35").Select
End Sub

.

Quantcast