Insert columns into worksheet (VBA?)

[lawi227]

I have a workbook that I am creating that does an analysis. The analysis can be done for 1 or 2 companies.

Rather than making changes manually (like adding columns to a worksheet), I would like to be able to type "1" or "2" in to a cell and have a code linked to that cell that will do the changes I need. This text box is located in cell E3 on a tab called "Instructions".

The first change I need is to add two columns to a worksheet.

When "2" is typed in to E3 on the "Instructions" tab, I need to duplicate columns I, J, K, L and paste them right after column L. Note: there is information in column M:Q. Below is an example of what my worksheet looks like (row 1 is the column letters, row 2 is the header names, row 3 is example data):

H	I	J	K	L	M	N	O	P	Q
Description	Notes	Depth	Breadth	Impact	Score	Rank	Gap	Avg.	Bucket
TEXT TEXT TEXT	TEXT TEXT	3	2	1	5	4	2	3	A

<tbody>
</tbody>

I need the new table to look like this:

H	I	J	K	L	M	N	O	P	Q	R
Description	Notes	Depth	Breadth	Impact	Score	Notes 2	Depth 2	Breadth 2	Impact 2	Score 2

<tbody>
</tbody>

Thanks!

 

[lawi227]

Bump. Is this practical, anyone?

 

[My Aswer Is This]

I looked at this but do not understand your examples. In your first example in row 2 you show Text Text Text
But in your second example you show: 2 2 2 2

 

[lawi227]

Row 1 of each table is the column.
Row 2 is the headers.
Row 3 is example data. "TEXT TEXT TEXT" means that it's just a string of words - not numbers.

In my new table example, I am trying to differentiate the headers. For example, I would need a header called "Notes" in Column I, and I would need another header called "Notes 2" in Column N.

Sorry I'm not very good at posting my tables into this forum. Still a beginner user of the forum..