Macro Copy / Paste Cells into new document

[ExcelSpencer]

Hi everyone this is my first post on Mr.Excel, I am pretty new to creating macros and was looking for some help from all of you Gurus .

I am having trouble trying to create a macro that could copy and paste into a new document for me. What the macro would essential do (if i could actually do it) is Copy Column A, Column B, Column D, Column F, Column H and paste it into a new document.

The trick is I need every Column except Column A to have 2 open columns after it. The new document would Be Column A with original Column A's information, Column B with original Column B's information, Column E with original Column D's information, Column H with original Column F's information...etc.

I think if I had help with this then I could edit the code myself to take my other information and paste it in those extra columns that I left open. I appreciate any help I can get with this, thank you all!

 

[MikeNDavis]

I think my strategy would be to copy the workbook to another, then open the copy and insert the columns you desire. Recording a macro will quickly show you how to insert the columns.