Insert Column using VBA

[Kartik27]

Hey

I have to Code a program using VBA which take a value ( say x) from a cell in Sheet1, B2. What I want to do is Insert New Columns in sheet2 based on the value entered in Sheet1, viz x . The no of the columns to be inserted have to be x * 2 + x after column D in Sheet2. Also these Columns needs to have a header Inverter1 Ac, Inverter1 DC, Inverter2 AC, Inverter2 DC and so on (x*2) times. Also the Later headers have to be Inverter1 Voltage, Inverter2 Voltage for (x) no of remaining columns.

I would really appreciate if anyone could help me with this project as I'm unable to progess without this.

Thanks a lot. Cheers

[LeoTaxi]

Excel file with sheet before and sheet after is a good start

Kind regards
Leo

[Kartik27]

Meaning? I didn't get you.