Help writing an easy VBA script - copying every nth column and inserting it next to it

[rob0762]

I would consider myself an advanced excel user, except I don't know anything about vba. I would appreciate your guys expertise in helping me get this done!

I have created a huge financial model and had it set up for 11 years, corresponding to 11 consecutive columns of equations. I need to add 2 extra columns at the end of each set of 11 columns.


Please see attachment...looking for a macro to able to run that would allow me to select a column letter to start (in this case column O:O), then it would go over to the end of the block of 11 columns (column Y:Y), copy that last column, and insert it twice after (after column Y:Y), then repeat this process with the next block of 11 columns until the last column in the worksheet (column AAD:AAD).

The attached example is only one of many worksheets that i need to add 2 columns to...so being able to run this macro on different tabs is crucial. Maybe to make it easier, I could inset a row at the top of the workbook, and put an "x" in the columns that needs duplicated twice to the left of it?


Thanks for your help!

-Rob

[haripopuri]

This should do the trick for you.

Please Login or Register  to view this content.

[rob0762]

haripopuri, thanks for your help, much appreciated!

[haripopuri]

Pls update thread as solved if this resolves the query. Thanks.