This is probably an easy macro to make, help please.

[bigmacfann]

I wish I knew how to program macros myself, is there a book or possibly an online resource? My real question is how to write a macro that does the following (in this exact order):
Move column H to column F
Move column I to column B
Move column K to column C
Move column O to column D
Move column Q to column J
Move column AB to column H
Move column AY to column I
Move column CG to column M
Move column FN to column E
Move column FO to column K
Clear columns A, G, L, N and everything after column N.

I'm certain that this is extremely easy for someone that knows what they're doing. I appreciate any help. Thank you.

 

[Smitty]

Welcome to the Board!

The easiest way to get that is to go to Tools-->Macros-->Record New Macro and record doing just what you listed.

Then feel free to post what you come up with so someone can show you how to clean it up.

Hope that helps,

Smitty