How do I create a macro to perform editing tasks in Excel?

S

sciencegod7@attenet

New member
Joined
Mar 19, 2009
Messages
1
Reaction score
0
Points
1
I have a document that I need to delete the SAME rows, delete the same columns, copy the date from one location to another, and then auto-fill...Certainly a macro can help me with this right? I'm self taught in Excel, but very proficient. Point me in the right direction, anyone?
 
The first step is to record a macro where you do everything you want to do

Tools->Macro->Record new macro

Then with a fresh sheet re-run the macro and see if it does what you expected it to do

If not then go to the macro editor and see if you can work out what to change too make the macro work repeatedly.
 
Back
Top