Merge worksheet contents with different headers - help please

sfordham · Aug 28, 2009

I am amazed at the things that I have seen on this forum - what you can do with excel is incredible.

I have many worksheets (40-50) from different sources with some or all of the information I need (language problem-community development work).

The worksheets provided to me do not have all the required headers and information for that column.
<link rel="File-List" href="file:///C:%5CUsers%5Csfordham%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_filelist.xml"><link rel="Preview" href="file:///C:%5CUsers%5Csfordham%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_preview.wmf"><link rel="themeData" href="file:///C:%5CUsers%5Csfordham%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_themedata.thmx"><link rel="colorSchemeMapping" href="file:///C:%5CUsers%5Csfordham%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml"><style>  </style>

<table class="MsoNormalTable" style="border: medium none ; width: 752.05pt; margin-left: 4.65pt; border-collapse: collapse;" align="left" border="1" cellpadding="0" cellspacing="0" width="1003"> <tbody><tr style="height: 12.75pt;"> <td style="border: 1pt solid windowtext; padding: 0cm 5.4pt; width: 73.95pt; height: 12.75pt;" valign="bottom" width="99"> [FONT=&quot]Worksheet 1<o

></o

>[/FONT]
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0cm 5.4pt; width: 73.9pt; height: 12.75pt;" valign="bottom" width="99">
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0cm 5.4pt; width: 58.45pt; height: 12.75pt;" valign="bottom" width="78">
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0cm 5.4pt; width: 2cm; height: 12.75pt;" valign="bottom" width="76">
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0cm 5.4pt; width: 49.6pt; height: 12.75pt;" valign="bottom" width="66">
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0cm 5.4pt; width: 106.35pt; height: 12.75pt;" valign="bottom" width="142">
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0cm 5.4pt; width: 77.95pt; height: 12.75pt;" valign="bottom" width="104">
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0cm 5.4pt; width: 79.7pt; height: 12.75pt;" valign="bottom" width="106">
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0cm 5.4pt; width: 83.3pt; height: 12.75pt;" valign="bottom" width="111">
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0cm 5.4pt; width: 92.15pt; height: 12.75pt;" valign="bottom" width="123">
</td> </tr> <tr style="height: 28.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 73.95pt; height: 28.75pt;" valign="top" width="99"> Center<o

></o

>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 73.9pt; height: 28.75pt;" valign="top" width="99"> Agreement<o

></o

>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 58.45pt; height: 28.75pt;" valign="top" width="78"> FirstName<o

></o

>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 2cm; height: 28.75pt;" valign="top" width="76"> LastName<o

></o

>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 49.6pt; height: 28.75pt;" valign="top" width="66"> Gender <o

></o

>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 106.35pt; height: 28.75pt;" valign="top" width="142"> ContactInformation<o

></o

>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 77.95pt; height: 28.75pt;" valign="top" width="104"> CourseName<o

></o

>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 79.7pt; height: 28.75pt;" valign="top" width="106"> CompanyName<o

></o

>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 83.3pt; height: 28.75pt;" valign="top" width="111"> BusinessActivity<o

></o

>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 92.15pt; height: 28.75pt;" valign="top" width="123"> Province<o

></o

>
</td> </tr> </tbody></table>

Additionally the Headers (and column information) when supplied is not in the same position - for example - "Agreement" could be in B2 in one worksheet and in K2 in another.
<link rel="File-List" href="file:///C:%5CUsers%5Csfordham%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_filelist.xml"><link rel="Preview" href="file:///C:%5CUsers%5Csfordham%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_preview.wmf"><link rel="themeData" href="file:///C:%5CUsers%5Csfordham%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_themedata.thmx"><link rel="colorSchemeMapping" href="file:///C:%5CUsers%5Csfordham%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml"><style>  </style>

<table class="MsoNormalTable" style="border: medium none ; width: 811.15pt; margin-left: -51.3pt; border-collapse: collapse;" align="left" border="1" cellpadding="0" cellspacing="0" width="1082"> <tbody><tr style="height: 12.75pt;"> <td style="border: 1pt solid windowtext; padding: 0cm 5.4pt; width: 73.9pt; height: 12.75pt;" valign="bottom" width="99"> [FONT=&quot]Worksheet18<o

></o

>[/FONT]
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0cm 5.4pt; width: 61.05pt; height: 12.75pt;" valign="bottom" width="81">
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0cm 5.4pt; width: 77.15pt; height: 12.75pt;" valign="bottom" width="103">
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0cm 5.4pt; width: 59.4pt; height: 12.75pt;" valign="bottom" width="79">
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0cm 5.4pt; width: 54pt; height: 12.75pt;" valign="bottom" width="72">
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0cm 5.4pt; width: 29.45pt; height: 12.75pt;" valign="bottom" width="39">
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0cm 5.4pt; width: 49.05pt; height: 12.75pt;" valign="bottom" width="65">
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0cm 5.4pt; width: 106.95pt; height: 12.75pt;" valign="bottom" width="143">
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0cm 5.4pt; width: 29.4pt; height: 12.75pt;" valign="bottom" width="39">
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0cm 5.4pt; width: 73.75pt; height: 12.75pt;" valign="bottom" width="98">
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0cm 5.4pt; width: 66.3pt; height: 12.75pt;" valign="bottom" width="88">
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0cm 5.4pt; width: 78pt; height: 12.75pt;" valign="bottom" width="104">
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0cm 5.4pt; width: 52.75pt; height: 12.75pt;" valign="bottom" width="70">
</td> </tr> <tr style="height: 38.2pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 73.9pt; height: 38.2pt;" valign="top" width="99"> Center<o

></o

>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 61.05pt; height: 38.2pt;" valign="top" width="81"> FirstName<o

></o

>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 77.15pt; height: 38.2pt;" valign="top" width="103"> MiddleName<o

></o

>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 59.4pt; height: 38.2pt;" valign="top" width="79"> LastName<o

></o

>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 54pt; height: 38.2pt;" valign="top" width="72"> Province<o

></o

>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 29.45pt; height: 38.2pt;" valign="top" width="39"> City<o

></o

>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 49.05pt; height: 38.2pt;" valign="top" width="65"> Gender <o

></o

>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 106.95pt; height: 38.2pt;" valign="top" width="143"> ContactInformation <o

></o

>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 29.4pt; height: 38.2pt;" valign="top" width="39"> Age<o

></o

>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 73.75pt; height: 38.2pt;" valign="top" width="98"> CourseName<o

></o

>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 66.3pt; height: 38.2pt;" valign="top" width="88"> Agreement<o

></o

>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 78pt; height: 38.2pt;" valign="top" width="104"> Company Name<o

></o

>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 52.75pt; height: 38.2pt;" valign="top" width="70"> Business Activity<o

></o

>
</td> </tr> </tbody></table>

I have a worksheet called ReportWorkSheet with the Headers as I need them.
<link rel="File-List" href="file:///C:%5CUsers%5Csfordham%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_filelist.xml"><link rel="Preview" href="file:///C:%5CUsers%5Csfordham%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_preview.wmf"><link rel="themeData" href="file:///C:%5CUsers%5Csfordham%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_themedata.thmx"><link rel="colorSchemeMapping" href="file:///C:%5CUsers%5Csfordham%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml"><style>  </style>

<table class="MsoNormalTable" style="border: medium none ; width: 772pt; margin-left: -58.4pt; border-collapse: collapse;" align="left" border="1" cellpadding="0" cellspacing="0" width="1029"> <tbody><tr style="height: 42.75pt;"> <td style="border: 1pt solid windowtext; padding: 0cm 5.4pt; width: 63.4pt; height: 42.75pt;" valign="bottom" width="85"> Report<o

></o

>
Worksheet<o

></o

>
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0cm 5.4pt; width: 64.65pt; height: 42.75pt;" valign="bottom" width="86">
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0cm 5.4pt; width: 37.45pt; height: 42.75pt;" valign="bottom" width="50">
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0cm 5.4pt; width: 61.7pt; height: 42.75pt;" valign="bottom" width="82">
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0cm 5.4pt; width: 55.75pt; height: 42.75pt;" valign="bottom" width="74">
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0cm 5.4pt; width: 49.6pt; height: 42.75pt;" valign="bottom" width="66">
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0cm 5.4pt; width: 1cm; height: 42.75pt;" valign="bottom" width="38">
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0cm 5.4pt; width: 64.2pt; height: 42.75pt;" valign="bottom" width="86">
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0cm 5.4pt; width: 56.3pt; height: 42.75pt;" valign="bottom" width="75">
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0cm 5.4pt; width: 70.9pt; height: 42.75pt;" valign="bottom" width="95">
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0cm 5.4pt; width: 35.4pt; height: 42.75pt;" valign="bottom" width="47">
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0cm 5.4pt; width: 49.65pt; height: 42.75pt;" valign="bottom" width="66">
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0cm 5.4pt; width: 1cm; height: 42.75pt;" valign="bottom" width="38">
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0cm 5.4pt; width: 53.1pt; height: 42.75pt;" valign="bottom" width="71">
</td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0cm 5.4pt; width: 53.2pt; height: 42.75pt;" valign="bottom" width="71">
</td> </tr> <tr style="height: 83.25pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 63.4pt; height: 83.25pt;" valign="top" width="85"> Center<o

></o

>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 64.65pt; height: 83.25pt;" valign="top" width="86"> Agreement<o

></o

>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 37.45pt; height: 83.25pt;" valign="top" width="50"> First<o

></o

>
Name<o

></o

>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 61.7pt; height: 83.25pt;" valign="top" width="82"> Middle<o

></o

>
Name<o

></o

>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 55.75pt; height: 83.25pt;" valign="top" width="74"> LastName<o

></o

>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 49.6pt; height: 83.25pt;" valign="top" width="66"> Gender<o

></o

>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 1cm; height: 83.25pt;" valign="top" width="38"> Age<o

></o

>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 64.2pt; height: 83.25pt;" valign="top" width="86"> Contact<o

></o

>
Information<o

></o

>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 56.3pt; height: 83.25pt;" valign="top" width="75"> Gender <o

></o

>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 70.9pt; height: 83.25pt;" valign="top" width="95"> Contact<o

></o

>
Information <o

></o

>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 35.4pt; height: 83.25pt;" valign="top" width="47"> Age<o

></o

>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 49.65pt; height: 83.25pt;" valign="top" width="66"> Province<o

></o

>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 1cm; height: 83.25pt;" valign="top" width="38"> City<o

></o

>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 53.1pt; height: 83.25pt;" valign="top" width="71"> Company<o

></o

>
Name<o

></o

>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 53.2pt; height: 83.25pt;" valign="top" width="71"> Business<o

></o

>
Activity<o

></o

>
</td> </tr> </tbody></table>

The worksheets supplied may have from 500 to 2000 rows in them and I need a macro or a routine I can apply to the worksheets to examine each header in the supplied worksheets, copy and paste to the ReportWorksheet in the next available row (a row containing no data from A to AZ) or maybe just to create a copy of the supplied worksheet rearranging the headers and information to the ReportWorksheet format. The I can just copy and paste all the worksheets to the ReportWorksheet.
The worksheets supplied have blank cells in them whcih I want to keep - the critical thing is to orient all headers and underlying information to the format in the Report Worksheet.

I would really appreciate help and even a quick reply if possible. Thanking You - Stephen

Merge worksheet contents with different headers - help please

sfordham

New Member

Excel Facts

Similar threads

Forum statistics

Share this page

Merge worksheet contents with different headers - help please

sfordham

New Member

Excel Facts

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock