Vba - find next empty column, insert column, copy paste values & copy paste formulas

[DoodlesMama]

I am creating a report that will be updated monthly then create charts with the newly pulled data.
I need to create code that will:

• find last column that contains data
• copy & paste values of that column (within that same column)
• find the next available blank column and insert a new column
• copy the master formula column
• paste formulas in the newly inserted column
• calculate
• Hide any columns older than 6 months.

[TABLE="class: grid, width: 1103, align: center"]
<TBODY>[TR]
[TD="colspan: 12"]

DATES BELOW NEED TO CALCULATE TODAY'S DATE THEN POPULATE THE PREVIOUS MONTH'S FIRST & LAST DAY</SPAN>​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]

MONTH START</SPAN>​

[/TD]
[TD="colspan: 2"]

11/1/2012</SPAN>​

[/TD]
[TD="colspan: 2"]

MONTH END</SPAN>​

[/TD]
[TD="colspan: 2"]

11/30/2012</SPAN>​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 5"]

<-----NEED TO HIDE------></SPAN>​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]

COPY PASTE VALUES</SPAN>​

[/TD]
[TD]

INSERT NEW COLUMN</SPAN>​

[/TD]
[TD][/TD]
[TD]MASTER FORMULAS</SPAN>
[/TD]
[/TR]
[TR]
[TD]

DAYS</SPAN>​

[/TD]
[TD]

31</SPAN>​

[/TD]
[TD]

29</SPAN>​

[/TD]
[TD]

31</SPAN>​

[/TD]
[TD]

30</SPAN>​

[/TD]
[TD]

31</SPAN>​

[/TD]
[TD]

30</SPAN>​

[/TD]
[TD]

31</SPAN>​

[/TD]
[TD]

31</SPAN>​

[/TD]
[TD]

30</SPAN>​

[/TD]
[TD]

31</SPAN>​

[/TD]
[TD]

30</SPAN>​

[/TD]
[TD][/TD]
[TD][/TD]
[TD]

FORMULA</SPAN>​

[/TD]
[/TR]
[TR]
[TD]

START</SPAN>​

[/TD]
[TD]

1/1/12</SPAN>​

[/TD]
[TD]

2/1/12</SPAN>​

[/TD]
[TD]

3/1/12</SPAN>​

[/TD]
[TD]

4/1/12</SPAN>​

[/TD]
[TD]

5/1/12</SPAN>​

[/TD]
[TD]

6/1/12</SPAN>​

[/TD]
[TD]

7/1/12</SPAN>​

[/TD]
[TD]

8/1/12</SPAN>​

[/TD]
[TD]

9/1/12</SPAN>​

[/TD]
[TD]

10/1/12</SPAN>​

[/TD]
[TD]

11/1/12</SPAN>​

[/TD]
[TD][/TD]
[TD][/TD]
[TD]

FORMULA</SPAN>​

[/TD]
[/TR]
[TR]
[TD]

END</SPAN>​

[/TD]
[TD]

1/31/12</SPAN>​

[/TD]
[TD]

2/29/12</SPAN>​

[/TD]
[TD]

3/31/12</SPAN>​

[/TD]
[TD]

4/30/12</SPAN>​

[/TD]
[TD]

5/31/12</SPAN>​

[/TD]
[TD]

6/30/12</SPAN>​

[/TD]
[TD]

7/31/12</SPAN>​

[/TD]
[TD]

8/31/12</SPAN>​

[/TD]
[TD]

9/30/12</SPAN>​

[/TD]
[TD]

10/31/12</SPAN>​

[/TD]
[TD]

11/30/12</SPAN>​

[/TD]
[TD][/TD]
[TD][/TD]
[TD]FORMULA</SPAN>
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

DATE RANGE</SPAN>​

[/TD]
[TD]

Jan 1 - 31, 2012</SPAN>​

[/TD]
[TD]

Feb 1 - 29, 2012</SPAN>​

[/TD]
[TD]

Mar 1 - 31, 2012</SPAN>​

[/TD]
[TD]

Apr 1 - 30, 2012</SPAN>​

[/TD]
[TD]

May 1 - 31, 2012</SPAN>​

[/TD]
[TD]

Jun 1 - 30, 2012</SPAN>​

[/TD]
[TD]

Jul 1 - 31, 2012</SPAN>​

[/TD]
[TD]

Aug 1 - 31, 2012</SPAN>​

[/TD]
[TD]

Sep 1 - 30, 2012</SPAN>​

[/TD]
[TD]

Oct 1 - 31, 2012</SPAN>​

[/TD]
[TD]

Nov 1 - 30, 2012</SPAN>​

[/TD]
[TD][/TD]
[TD][/TD]
[TD]FORMULA</SPAN>
[/TD]
[/TR]
[TR]
[TD]

DATA TYPE1</SPAN>​

[/TD]
[TD]

1024</SPAN>​

[/TD]
[TD]

1038</SPAN>​

[/TD]
[TD]

1048</SPAN>​

[/TD]
[TD]

1060</SPAN>​

[/TD]
[TD]

1063</SPAN>​

[/TD]
[TD]

1069</SPAN>​

[/TD]
[TD]

1182</SPAN>​

[/TD]
[TD]

1196</SPAN>​

[/TD]
[TD]

1206</SPAN>​

[/TD]
[TD]

1217</SPAN>​

[/TD]
[TD]

1224</SPAN>​

[/TD]
[TD][/TD]
[TD][/TD]
[TD]

FORMULA</SPAN>​

[/TD]
[/TR]
[TR]
[TD]

DATA TYPE2</SPAN>​

[/TD]
[TD]

332</SPAN>​

[/TD]
[TD]

339</SPAN>​

[/TD]
[TD]

301</SPAN>​

[/TD]
[TD]

284</SPAN>​

[/TD]
[TD]

339</SPAN>​

[/TD]
[TD]

353</SPAN>​

[/TD]
[TD]

497</SPAN>​

[/TD]
[TD]

565</SPAN>​

[/TD]
[TD]

594</SPAN>​

[/TD]
[TD]

648</SPAN>​

[/TD]
[TD]

532</SPAN>​

[/TD]
[TD][/TD]
[TD][/TD]
[TD]

FORMULA</SPAN>​

[/TD]
[/TR]
[TR]
[TD]

DATA TYPE3</SPAN>​

[/TD]
[TD]

296</SPAN>​

[/TD]
[TD]

291</SPAN>​

[/TD]
[TD]

249</SPAN>​

[/TD]
[TD]

248</SPAN>​

[/TD]
[TD]

278</SPAN>​

[/TD]
[TD]

301</SPAN>​

[/TD]
[TD]

403</SPAN>​

[/TD]
[TD]

492</SPAN>​

[/TD]
[TD]

520</SPAN>​

[/TD]
[TD]

593</SPAN>​

[/TD]
[TD]

478</SPAN>​

[/TD]
[TD][/TD]
[TD][/TD]
[TD]FORMULA</SPAN>
[/TD]
[/TR]
</TBODY>[/TABLE]