Writing Excel Macro

M

McHarrisco

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
 
N

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.
 
Top