Macro to execute Text-Columns, Del 2 Extra Cells and Forma

[dahvaio]

I run 2 reports every week and I was wondering if there was a way to automate what I am doing. I run a report; however, I have to do the following in order to get the format correct:

1: Add 2 Extra Blank Colums after COL F
2: Run Text to Columns on COL F (Delimited by SPACE)
3: Del extra Columns (G & H) "I do not need the TIME and AM/PM Format)
4: Format COL F with Date (03/14/02) Format


Here is an example of a BEFORE and AFTER:

Book1
	A	B	C	D	E	F	G	H
1	BEFORE
2	Incident#	AffectedItem	Severity	Customer	Contacted	Date	Technician	Submitter
3	1001	HHFCSoftware	Three	Customer1		8/28/20068:07	Tech1	Sub1
4	1002	HHFCPDA/Service	Four	Customer2	Yes	9/28/200610:32	Tech2	Sub2
5	1003	HHFNPDA/Service	Four	Customer3	Yes	8/31/20067:43	Tech3	Sub3
6	1004	HHFCSoftware	Four	Customer4	Yes	8/28/200613:33	Tech4	Sub4
7
8	AFTER
9	Incident#	AffectedItem	Severity	Customer	Contacted	Date	Technician	Submitter
10	1001	HHFCSoftware	Three	Customer1		8/28/2006	Tech1	Sub1
11	1002	HHFCPDA/Service	Four	Customer2	Yes	9/28/2006	Tech2	Sub2
12	1003	HHFNPDA/Service	Four	Customer3	Yes	8/31/2006	Tech3	Sub3
13	1004	HHFCSoftware	Four	Customer4	Yes	8/28/2006	Tech4	Sub4
Sheet1