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!
<tbody>
[TD="class: xl67"]Coverage Start Date[/TD]
[TD="class: xl68, width: 167"]Coverage End Date[/TD]
[TD="class: xl68, width: 138"]Initial Calc Date[/TD]
[TD="class: xl68, width: 132"]Signature Date[/TD]
[TD="class: xl68, width: 138"]Coverage Name[/TD]
[TD="class: xl68, width: 154"]Coverage Volume[/TD]
[TD="class: xl68, width: 175"]Coverage Start Date[/TD]
[TD="class: xl68, width: 167"]Coverage End Date[/TD]
[TD="class: xl68, width: 138"]Initial Calc Date[/TD]
[TD="class: xl68, width: 132"]Signature Date[/TD]
[TD="class: xl68, width: 138"]Coverage Name[/TD]
[TD="class: xl69, width: 154"]Coverage Volume[/TD]
[TD="class: xl70"]07/01/2015[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl65"]TESTADD1[/TD]
[TD="class: xl65"]50000[/TD]
[TD="class: xl65"]07/01/2015[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl65"]testlife[/TD]
[TD="class: xl71"]1[/TD]
[TD="class: xl70"]07/01/2015[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl65"]testlife[/TD]
[TD="class: xl65"]50000[/TD]
[TD="class: xl65"]07/01/2015[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl65"]testlife[/TD]
[TD="class: xl71"]1[/TD]
[TD="class: xl70"]07/01/2015[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl65"]testlife[/TD]
[TD="class: xl65"]50000[/TD]
[TD="class: xl65"]07/01/2015[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl65"]testlife[/TD]
[TD="class: xl71"]1[/TD]
[TD="class: xl70"]07/01/2015[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl65"]testlife[/TD]
[TD="class: xl65"]50000[/TD]
[TD="class: xl65"]07/01/2015[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl65"]testlife[/TD]
[TD="class: xl71"]1[/TD]
[TD="class: xl70"]07/01/2015[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl65"]testlife[/TD]
[TD="class: xl65"]50000[/TD]
[TD="class: xl65"]07/01/2015[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl65"]testlife[/TD]
[TD="class: xl71"]1[/TD]
[TD="class: xl70"]07/01/2015[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl65"]testlife[/TD]
[TD="class: xl65"]50000[/TD]
[TD="class: xl65"]07/01/2015[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl65"]testlife[/TD]
[TD="class: xl71"]1[/TD]
[TD="class: xl70"]07/01/2015[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl65"]testlife[/TD]
[TD="class: xl65"]50000[/TD]
[TD="class: xl65"]07/01/2015[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl65"]testlife[/TD]
[TD="class: xl71"]1[/TD]
[TD="class: xl70"]07/01/2015[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl65"]testlife[/TD]
[TD="class: xl65"]50000[/TD]
[TD="class: xl65"]07/01/2015[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl65"]testlife[/TD]
[TD="class: xl71"]1[/TD]
[TD="class: xl70"]07/01/2015[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl65"]TESTADD1[/TD]
[TD="class: xl65"]50000[/TD]
[TD="class: xl65"]07/01/2015[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl65"]testlife[/TD]
[TD="class: xl71"]1[/TD]
[TD="class: xl70"]07/01/2015[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl65"]TESTADD1[/TD]
[TD="class: xl65"]50000[/TD]
[TD="class: xl65"]07/01/2015[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl65"]testlife[/TD]
[TD="class: xl71"]1[/TD]
[TD="class: xl70"]07/01/2015[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl65"]TESTADD1[/TD]
[TD="class: xl65"]50000[/TD]
[TD="class: xl65"]07/01/2015[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl65"]testlife[/TD]
[TD="class: xl71"]1[/TD]
[TD="class: xl70"]07/01/2015[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl65"]TESTADD1[/TD]
[TD="class: xl65"]50000[/TD]
[TD="class: xl65"]07/01/2015[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl65"]testlife[/TD]
[TD="class: xl71"]1[/TD]
[TD="class: xl72"]07/01/2015[/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl74"]TESTADD1[/TD]
[TD="class: xl74"]50000[/TD]
[TD="class: xl74"]07/01/2015[/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl74"]testlife[/TD]
[TD="class: xl75"]1[/TD]
</tbody>
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!
<tbody>
[TD="class: xl67"]Coverage Start Date[/TD]
[TD="class: xl68, width: 167"]Coverage End Date[/TD]
[TD="class: xl68, width: 138"]Initial Calc Date[/TD]
[TD="class: xl68, width: 132"]Signature Date[/TD]
[TD="class: xl68, width: 138"]Coverage Name[/TD]
[TD="class: xl68, width: 154"]Coverage Volume[/TD]
[TD="class: xl68, width: 175"]Coverage Start Date[/TD]
[TD="class: xl68, width: 167"]Coverage End Date[/TD]
[TD="class: xl68, width: 138"]Initial Calc Date[/TD]
[TD="class: xl68, width: 132"]Signature Date[/TD]
[TD="class: xl68, width: 138"]Coverage Name[/TD]
[TD="class: xl69, width: 154"]Coverage Volume[/TD]
[TD="class: xl70"]07/01/2015[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl65"]TESTADD1[/TD]
[TD="class: xl65"]50000[/TD]
[TD="class: xl65"]07/01/2015[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl65"]testlife[/TD]
[TD="class: xl71"]1[/TD]
[TD="class: xl70"]07/01/2015[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl65"]testlife[/TD]
[TD="class: xl65"]50000[/TD]
[TD="class: xl65"]07/01/2015[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl65"]testlife[/TD]
[TD="class: xl71"]1[/TD]
[TD="class: xl70"]07/01/2015[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl65"]testlife[/TD]
[TD="class: xl65"]50000[/TD]
[TD="class: xl65"]07/01/2015[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl65"]testlife[/TD]
[TD="class: xl71"]1[/TD]
[TD="class: xl70"]07/01/2015[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl65"]testlife[/TD]
[TD="class: xl65"]50000[/TD]
[TD="class: xl65"]07/01/2015[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl65"]testlife[/TD]
[TD="class: xl71"]1[/TD]
[TD="class: xl70"]07/01/2015[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl65"]testlife[/TD]
[TD="class: xl65"]50000[/TD]
[TD="class: xl65"]07/01/2015[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl65"]testlife[/TD]
[TD="class: xl71"]1[/TD]
[TD="class: xl70"]07/01/2015[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl65"]testlife[/TD]
[TD="class: xl65"]50000[/TD]
[TD="class: xl65"]07/01/2015[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl65"]testlife[/TD]
[TD="class: xl71"]1[/TD]
[TD="class: xl70"]07/01/2015[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl65"]testlife[/TD]
[TD="class: xl65"]50000[/TD]
[TD="class: xl65"]07/01/2015[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl65"]testlife[/TD]
[TD="class: xl71"]1[/TD]
[TD="class: xl70"]07/01/2015[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl65"]testlife[/TD]
[TD="class: xl65"]50000[/TD]
[TD="class: xl65"]07/01/2015[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl65"]testlife[/TD]
[TD="class: xl71"]1[/TD]
[TD="class: xl70"]07/01/2015[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl65"]TESTADD1[/TD]
[TD="class: xl65"]50000[/TD]
[TD="class: xl65"]07/01/2015[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl65"]testlife[/TD]
[TD="class: xl71"]1[/TD]
[TD="class: xl70"]07/01/2015[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl65"]TESTADD1[/TD]
[TD="class: xl65"]50000[/TD]
[TD="class: xl65"]07/01/2015[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl65"]testlife[/TD]
[TD="class: xl71"]1[/TD]
[TD="class: xl70"]07/01/2015[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl65"]TESTADD1[/TD]
[TD="class: xl65"]50000[/TD]
[TD="class: xl65"]07/01/2015[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl65"]testlife[/TD]
[TD="class: xl71"]1[/TD]
[TD="class: xl70"]07/01/2015[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl65"]TESTADD1[/TD]
[TD="class: xl65"]50000[/TD]
[TD="class: xl65"]07/01/2015[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl65"]testlife[/TD]
[TD="class: xl71"]1[/TD]
[TD="class: xl72"]07/01/2015[/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl74"]TESTADD1[/TD]
[TD="class: xl74"]50000[/TD]
[TD="class: xl74"]07/01/2015[/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl74"]testlife[/TD]
[TD="class: xl75"]1[/TD]
</tbody>