Need assistance with A Macro to place like data in the same column

[pete3636]

I am hoping someone can assist with creating the macro I am attempting. I would like to have explorer open, allowing me to map to the file location to pull the file in. Once the file is opened I would like the macro to organize the data so that like coverage names are placed in the correct columns with their corresponding additional column data.

In the example below, the macro would move from any column that contains testlife into column AL. Since there are 4 columns associated to each coverage name (start date\end date\ calc date\signature date\volume; all of those should be organized together.

I apologize if I am not explaining this correctly, but that may explain why I cannot figure it out! I appreciate anyone reviewing this and any assistance would be appreciated.

Thank you!

Coverage Start Date	Coverage End Date	Initial Calc Date	Signature Date	Coverage Name	Coverage Volume	Coverage Start Date	Coverage End Date	Initial Calc Date	Signature Date	Coverage Name	Coverage Volume
07/01/2015				TESTADD1	50000	07/01/2015				testlife	1
07/01/2015				testlife	50000	07/01/2015				testlife	1
07/01/2015				testlife	50000	07/01/2015				testlife	1
07/01/2015				testlife	50000	07/01/2015				testlife	1
07/01/2015				testlife	50000	07/01/2015				testlife	1
07/01/2015				testlife	50000	07/01/2015				testlife	1
07/01/2015				testlife	50000	07/01/2015				testlife	1
07/01/2015				testlife	50000	07/01/2015				testlife	1
07/01/2015				TESTADD1	50000	07/01/2015				testlife	1
07/01/2015				TESTADD1	50000	07/01/2015				testlife	1
07/01/2015				TESTADD1	50000	07/01/2015				testlife	1
07/01/2015				TESTADD1	50000	07/01/2015				testlife	1
07/01/2015				TESTADD1	50000	07/01/2015				testlife	1

<tbody>
</tbody>

 

[pete3636]

bump