Help writing macro for +1 and -1 Columns (sample file attached)

Ok, so i'm attaching a simple sample of the file i'm playing around with.

What i'm trying to do is make it so I can add a single new column with all the same data and formulas in order, so it stays in series.

I know how to write a macro to do this, my problem is writing one that can keep adding, so like I activate the macro and it adds a new column then i hit it again and it adds another one directly after the one just added and so on and so on.

I would also like a macro to do the same but in reverse, so when i'm done or if I add to many i can get rid of them by simply hitting the button.

Thank you for any help!

Further detail will be in the file attached.

Thanks! That does work.

So, basic premis is down...now...what I REALLY need is to know how to do this myself? Im sorry if its asking alot but, is there a way you can do a step by step?

Because I want to do this, but to add a column to multipule sheets inside the workbook at a time.

If i know the process to do it for one worksheet, I can do it to multipule. THANK YOU SOOO MUCH if you can!

I'm not trying to be picky but, I dont really understand that :-/

By step by step, i meant like if i hit "record macro" what would I do? Just need for how to do what you did for one sheet, after that I can just move to the next sheet instead of stopping the macro recording.

Thanks again,

Originally Posted by mikerickson

This macro will do all the worksheets in a work book

It doesnt, and I think it doesnt because not all the sheets in the workbook are the same as that very first one.

I'm sorry if this is annoying or too hard/much work, :-/

Yeah, I posted above the attachment the password, its DrillMeet