Writing Excel Macro

[Guest]

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

 

[Niek Otten]

The best way to learn to do that is to do your actions manually, and record
them via Tools>Macros>Record 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.