The best way to learn to do that is to do your actions manually, and record
them via ToolsMacrosRecord new macro
After having done that, open the VB Editor (ALT+F11), look for a folder
Modules in your VBAProject and double-click Module1 (and the next time...
you get it)
There you can see how Excel translated your actions into VBA.

--
Kind regards,

Niek Otten

"McHarrisco" wrote in message
...
I have never written an Excel Macro. Where do I start?
I want to take data from one spreadsheet, and insert it into another on a
monthly and cumulative basis. I have version 2000.

Mac