Split two or more text in a column into rows without changing it associated row

E

elfasus

New Member
Joined
Jun 17, 2011
Messages
7
I have a worksheet with a data distributed as follows :


-- removed inline image ---
<table border="0" cellpadding="0" cellspacing="0" width="548"><colgroup><col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:2450; width:50pt" span="4" width="67"> <col style="mso-width-source:userset;mso-width-alt:2998;width:62pt" width="82"> <col style="mso-width-source:userset;mso-width-alt:2450; width:50pt" span="2" width="67"> </colgroup><tbody><tr style="height:15.0pt" height="20"> <td style="height:15.0pt;width:48pt" width="64" height="20">
</td> <td style="width:50pt" width="67">Column B</td> <td style="width:50pt" width="67">Column C</td> <td style="width:50pt" width="67">Column D</td> <td style="width:50pt" width="67">Column E</td> <td style="width:62pt" width="82">Column F</td> <td style="width:50pt" width="67">Column G</td> <td style="width:50pt" width="67">Column H</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">Row 2</td> <td>B2</td> <td>C2</td> <td>D2</td> <td>E2</td> <td>A B C </td> <td>G2</td> <td>H2</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">Row 3</td> <td>B3</td> <td>C3</td> <td>D3</td> <td>E3</td> <td>A B </td> <td>G3</td> <td>H3</td> </tr> </tbody></table>

and i want to split data in columns F into rows and without changing it associated row

and the final result would be like as follows:


-- removed inline image ---
<table border="0" cellpadding="0" cellspacing="0" width="548"><colgroup><col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:2450; width:50pt" span="4" width="67"> <col style="mso-width-source:userset;mso-width-alt:2998;width:62pt" width="82"> <col style="mso-width-source:userset;mso-width-alt:2450; width:50pt" span="2" width="67"> </colgroup><tbody><tr style="height:15.0pt" height="20"> <td style="height:15.0pt;width:48pt" width="64" height="20">
</td> <td style="width:50pt" width="67">Column B</td> <td style="width:50pt" width="67">Column C</td> <td style="width:50pt" width="67">Column D</td> <td style="width:50pt" width="67">Column E</td> <td style="width:62pt" width="82">Column F</td> <td style="width:50pt" width="67">Column G</td> <td style="width:50pt" width="67">Column H</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">Row 2</td> <td>B2</td> <td>C2</td> <td>D2</td> <td>E2</td> <td>A</td> <td>G2</td> <td>H2</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">Row 3</td> <td>B2</td> <td>C2</td> <td>D2</td> <td>E2</td> <td>B</td> <td>G2</td> <td>H2</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">Row 4</td> <td>B2</td> <td>C2</td> <td>D2</td> <td>E2</td> <td>C</td> <td>G2</td> <td>H2</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">Row 5
</td> <td>B3</td> <td>C3</td> <td>D3</td> <td>E3</td> <td>A</td> <td>G3</td> <td>H3</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">Row 6
</td> <td>B3</td> <td>C3</td> <td>D3</td> <td>E3</td> <td>B</td> <td>G3</td> <td>H3</td> </tr> </tbody></table>

Could you please help me?

Thank you in advance
Regards,
Elf
 
Sort by date Sort by votes
Dear mirabeau,

Sorry for bother again, i was trying to modified your macro code, but in the end i got stuck and mess up all the code that you advise to me. and i have no other choice except asking for your help again, but this time i give you my real data format with dummy data.
Please your help and effort again to solve this problem
Thanks a lot in advance

Andy (Elf)

Data as follows (in sheet1) :

<table border="0" cellpadding="0" cellspacing="0" width="4550"><colgroup><col style="mso-width-source:userset;mso-width-alt:4388; width:90pt" span="2" width="120"> <col style="mso-width-source:userset;mso-width-alt:5120;width:105pt" width="140"> <col style="mso-width-source:userset;mso-width-alt:4388;width:90pt" width="120"> <col style="mso-width-source:userset;mso-width-alt:4461;width:92pt" width="122"> <col style="mso-width-source:userset;mso-width-alt:3766;width:77pt" width="103"> <col style="mso-width-source:userset;mso-width-alt:5412;width:111pt" width="148"> <col style="mso-width-source:userset;mso-width-alt:5339;width:110pt" width="146"> <col style="mso-width-source:userset;mso-width-alt:4608;width:95pt" width="126"> <col style="mso-width-source:userset;mso-width-alt:3693;width:76pt" width="101"> <col style="mso-width-source:userset;mso-width-alt:5120;width:105pt" width="140"> <col style="mso-width-source:userset;mso-width-alt:3730;width:77pt" width="102"> <col style="mso-width-source:userset;mso-width-alt:3840; width:79pt" span="2" width="105"> <col style="mso-width-source:userset;mso-width-alt:4498;width:92pt" width="123"> <col style="mso-width-source:userset;mso-width-alt:4608; width:95pt" span="2" width="126"> <col style="mso-width-source:userset;mso-width-alt:3510;width:72pt" width="96"> <col style="mso-width-source:userset;mso-width-alt:5668;mso-outline-parent: collapsed;width:116pt" width="155"> <col style="mso-width-source:userset;mso-width-alt:3986;width:82pt" width="109"> <col style="mso-width-source:userset;mso-width-alt:4096; width:84pt" span="2" width="112"> <col style="mso-width-source:userset;mso-width-alt:5632;width:116pt" width="154"> <col style="mso-width-source:userset;mso-width-alt:3949;width:81pt" width="108"> <col style="mso-width-source:userset;mso-width-alt:4864;width:100pt" width="133"> <col style="mso-width-source:userset;mso-width-alt:4132;width:85pt" width="113"> <col style="mso-width-source:userset;mso-width-alt:6034;width:124pt" width="165"> <col style="mso-width-source:userset;mso-width-alt:3547;width:73pt" width="97"> <col style="mso-width-source:userset;mso-width-alt:3693;width:76pt" width="101"> <col style="mso-width-source:userset;mso-width-alt:5814;width:119pt" width="159"> <col style="mso-width-source:userset;mso-width-alt:3693;width:76pt" width="101"> <col style="mso-width-source:userset;mso-width-alt:4608;width:95pt" width="126"> <col style="mso-width-source:userset;mso-width-alt:5010;width:103pt" width="137"> <col style="mso-width-source:userset;mso-width-alt:5302;width:109pt" width="145"> <col style="mso-width-source:userset;mso-width-alt:5558;width:114pt" width="152"> <col style="mso-width-source:userset;mso-width-alt:7387;width:152pt" width="202"> </colgroup><tbody><tr style="height:12.0pt" height="16"> <td class="xl166" style="height:12.0pt;width:90pt" width="120" height="16">Company Name</td> <td class="xl166" style="width:90pt" width="120">XXX</td> <td class="xl166" style="width:105pt" width="140">
</td> <td class="xl161" style="width:90pt" width="120">
</td> <td class="xl161" style="width:92pt" width="122">
</td> <td class="xl161" style="width:77pt" width="103">
</td> <td class="xl161" style="width:111pt" width="148">
</td> <td class="xl162" style="width:110pt" width="146">
</td> <td class="xl162" style="width:95pt" width="126">
</td> <td class="xl162" style="width:76pt" width="101">
</td> <td class="xl162" style="width:105pt" width="140">
</td> <td class="xl162" style="width:77pt" width="102">
</td> <td class="xl162" style="width:79pt" width="105">
</td> <td class="xl162" style="width:79pt" width="105">
</td> <td class="xl162" style="width:92pt" width="123">
</td> <td class="xl162" style="width:95pt" width="126">
</td> <td class="xl163" style="width:95pt" width="126">
</td> <td class="xl164" style="width:72pt" width="96">
</td> <td class="xl161" style="width:116pt" width="155">
</td> <td class="xl161" style="width:82pt" width="109">
</td> <td class="xl161" style="width:84pt" width="112">
</td> <td class="xl161" style="width:84pt" width="112">
</td> <td class="xl161" style="width:116pt" width="154">
</td> <td class="xl161" style="width:81pt" width="108">
</td> <td class="xl161" style="width:100pt" width="133">
</td> <td class="xl161" style="width:85pt" width="113">
</td> <td class="xl161" style="width:124pt" width="165">
</td> <td class="xl161" style="width:73pt" width="97">
</td> <td class="xl173" style="width:76pt" width="101">
</td> <td class="xl165" style="width:119pt" width="159">
</td> <td class="xl161" style="width:76pt" width="101">
</td> <td class="xl161" style="width:95pt" width="126">
</td> <td class="xl161" style="width:103pt" width="137">
</td> <td class="xl161" style="width:109pt" width="145">
</td> <td class="xl161" style="width:114pt" width="152">
</td> <td class="xl161" style="width:152pt" width="202">
</td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl166" style="height:12.0pt" height="16">Company Address</td> <td class="xl166">YYY111</td> <td class="xl166">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl163">
</td> <td class="xl164">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl173">
</td> <td class="xl165">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl166" style="height:12.0pt" height="16">Company Address</td> <td class="xl166">YYY222</td> <td class="xl166">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl163">
</td> <td class="xl164">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl173">
</td> <td class="xl165">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl166" style="height:12.0pt" height="16">Company Address</td> <td class="xl166">YYY333</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl163">
</td> <td class="xl164">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl173">
</td> <td class="xl165">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl166" style="height:12.0pt" height="16">Period</td> <td class="xl167">DD/MM/YYYY</td> <td class="xl168">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl163">
</td> <td class="xl164">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl173">
</td> <td class="xl165">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl166" style="height:12.0pt" height="16">
</td> <td class="xl169">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl163">
</td> <td class="xl164">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl173">
</td> <td class="xl165">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> </tr> <tr style="height:12.0pt" height="16"> <td colspan="18" class="xl172" style="height:12.0pt" height="16">Reception Unit</td> <td colspan="13" class="xl172" style="border-left:none">Mechanical Unit</td> <td colspan="5" class="xl172" style="border-left:none">Control Unit</td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl172" style="height:12.0pt;border-top:none" height="16">No.</td> <td class="xl170" style="border-top:none;border-left:none">Arrival Date</td> <td class="xl172" style="border-top:none;border-left:none">Customer Type</td> <td class="xl172" style="border-top:none;border-left:none">Form No. 01</td> <td class="xl172" style="border-top:none;border-left:none">Form No. 02</td> <td class="xl172" style="border-top:none;border-left:none">Unit Type</td> <td class="xl172" style="border-top:none;border-left:none">Item Description</td> <td class="xl172" style="border-top:none;border-left:none">Customer Name</td> <td class="xl172" style="border-top:none;border-left:none">Landing Date</td> <td class="xl172" style="border-top:none;border-left:none">Revision</td> <td class="xl172" style="border-top:none;border-left:none">Issue Reported</td> <td class="xl172" style="border-top:none;border-left:none">Status 01</td> <td class="xl172" style="border-top:none;border-left:none">Status 02</td> <td class="xl172" style="border-top:none;border-left:none">Status 03</td> <td class="xl172" style="border-top:none;border-left:none">Gear Date 01</td> <td class="xl172" style="border-top:none;border-left:none">Gear Date 02</td> <td class="xl170" style="border-top:none;border-left:none">Gear Date 03</td> <td class="xl171" style="border-top:none;border-left:none">Counter</td> <td class="xl170" style="border-top:none;border-left:none">Breaktrough Date</td> <td class="xl172" style="border-top:none;border-left:none">Reason 01</td> <td class="xl172" style="border-top:none;border-left:none">Reason 02</td> <td class="xl172" style="border-top:none;border-left:none">Reason 03</td> <td class="xl172" style="border-top:none;border-left:none">Part Name</td> <td class="xl172" style="border-top:none;border-left:none">Usage Qty</td> <td class="xl172" style="border-top:none;border-left:none">Departing Loc</td> <td class="xl172" style="border-top:none;border-left:none">Sub Status</td> <td class="xl172" style="border-top:none;border-left:none">Sub Status Reason</td> <td class="xl172" style="border-top:none;border-left:none">Entry By</td> <td class="xl174" style="border-top:none;border-left:none">Departing Date</td> <td class="xl171" style="border-top:none;border-left:none">Departing Counter</td> <td class="xl172" style="border-top:none;border-left:none">Remarks</td> <td class="xl172" style="border-top:none;border-left:none">Control Date</td> <td class="xl172" style="border-top:none;border-left:none">Control Status</td> <td class="xl172" style="border-top:none;border-left:none">Control goes to</td> <td class="xl172" style="border-top:none;border-left:none">Control Remarks</td> <td class="xl172" style="border-top:none;border-left:none">Control Additional Notes</td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl182" style="height:12.0pt" height="16">1</td> <td class="xl183" style="border-left:none">31-May-11</td> <td class="xl176" style="border-left:none">A01</td> <td class="xl180" style="border-left:none">A901791</td> <td class="xl180" style="border-left:none">MAC909902</td> <td class="xl180" style="border-left:none">B001</td> <td align="left" valign="top">
clip_image002.gif
<table cellpadding="0" cellspacing="0"> <tbody><tr> <td class="xl180" style="height:12.0pt;border-left:none; width:111pt" width="148" height="16">XXX</td> </tr> </tbody></table> </td> <td class="xl180" style="border-left:none">AAA</td> <td class="xl176" style="border-left:none">31-Jul-13</td> <td class="xl180" style="border-left:none">Ver 7.1</td> <td class="xl176" style="border-left:none">YYY</td> <td class="xl180" style="border-left:none">I01</td> <td class="xl176" style="border-left:none">E </td> <td class="xl176" style="border-left:none">C</td> <td class="xl176" style="border-left:none">30-May-11</td> <td class="xl176" style="border-left:none">30-May-11</td> <td class="xl178" style="border-left:none">-</td> <td class="xl181" style="border-left:none">1</td> <td class="xl176" style="border-left:none">1-Jun-11</td> <td class="xl177" style="border-left:none"> Z00P09 X09Y02 </td> <td class="xl177" style="border-left:none"> R11 E23 </td> <td class="xl177" style="border-left:none"> 00BC EF </td> <td class="xl177" style="border-left:none"> 07HB10087G 93GII8893 </td> <td class="xl184" style="border-left:none">2</td> <td class="xl177" style="border-left:none"> BEN01 JHN04 </td> <td class="xl175" style="border-left:none">GOOD</td> <td class="xl175" style="border-left:none"> </td> <td class="xl177" style="border-left:none"> MEU02 </td> <td class="xl176" style="border-left:none">1-Jun-11</td> <td class="xl179" style="border-left:none">0</td> <td class="xl177" style="border-left:none"> BBB </td> <td class="xl176" style="border-left:none">1-Jun-11</td> <td class="xl177" style="border-left:none"> GOOD </td> <td class="xl177" style="border-left:none"> Log </td> <td class="xl177" style="border-left:none"> AAA </td> <td class="xl177" style="border-left:none"> CCC </td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl182" style="height:12.0pt;border-top:none" height="16">2</td> <td class="xl183" style="border-top:none;border-left:none">31-May-11</td> <td class="xl176" style="border-top:none;border-left:none">A01</td> <td class="xl180" style="border-top:none;border-left:none">A901882</td> <td class="xl180" style="border-top:none;border-left:none">MAC909332</td> <td class="xl180" style="border-top:none;border-left:none">B001</td> <td class="xl180" style="border-top:none;border-left:none">XXX</td> <td class="xl180" style="border-top:none;border-left:none">BBB</td> <td class="xl176" style="border-top:none;border-left:none">31-Dec-13</td> <td class="xl180" style="border-top:none;border-left:none">Ver 8.2</td> <td class="xl176" style="border-top:none;border-left:none">YYY</td> <td class="xl180" style="border-top:none;border-left:none">I01</td> <td class="xl176" style="border-top:none;border-left:none">E</td> <td class="xl176" style="border-top:none;border-left:none">C</td> <td class="xl176" style="border-top:none;border-left:none">31-May-11</td> <td class="xl176" style="border-top:none;border-left:none">31-May-11</td> <td class="xl178" style="border-top:none;border-left:none">-</td> <td class="xl181" style="border-top:none;border-left:none">1</td> <td class="xl176" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl177" style="border-top:none;border-left:none"> X0P030 YYA309 </td> <td class="xl177" style="border-top:none;border-left:none"> R11 B32 </td> <td class="xl177" style="border-top:none;border-left:none"> GAYY B89F </td> <td class="xl177" style="border-top:none;border-left:none"> 03JJ893392 09YYNM09304 </td> <td class="xl184" style="border-top:none;border-left:none">2</td> <td class="xl177" style="border-top:none;border-left:none"> SBI55 KON77 </td> <td class="xl175" style="border-top:none;border-left:none">GOOD</td> <td class="xl175" style="border-top:none;border-left:none"> </td> <td class="xl177" style="border-top:none;border-left:none"> MEU02 </td> <td class="xl176" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl179" style="border-top:none;border-left:none">0</td> <td class="xl177" style="border-top:none;border-left:none"> BBB </td> <td class="xl176" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl177" style="border-top:none;border-left:none"> GOOD </td> <td class="xl177" style="border-top:none;border-left:none"> Log </td> <td class="xl177" style="border-top:none;border-left:none"> AAA </td> <td class="xl177" style="border-top:none;border-left:none"> CCC </td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl182" style="height:12.0pt;border-top:none" height="16">3</td> <td class="xl183" style="border-top:none;border-left:none">31-May-11</td> <td class="xl176" style="border-top:none;border-left:none">B02</td> <td class="xl180" style="border-top:none;border-left:none">B902920</td> <td class="xl180" style="border-top:none;border-left:none">MBC903234</td> <td class="xl180" style="border-top:none;border-left:none">B002</td> <td class="xl180" style="border-top:none;border-left:none">XXX</td> <td class="xl180" style="border-top:none;border-left:none">CCC</td> <td class="xl176" style="border-top:none;border-left:none">31-Oct-13</td> <td class="xl180" style="border-top:none;border-left:none">Ver 7.1</td> <td class="xl176" style="border-top:none;border-left:none">YYY</td> <td class="xl180" style="border-top:none;border-left:none">I01</td> <td class="xl176" style="border-top:none;border-left:none">E</td> <td class="xl176" style="border-top:none;border-left:none">C</td> <td class="xl176" style="border-top:none;border-left:none">31-May-11</td> <td class="xl176" style="border-top:none;border-left:none">31-May-11</td> <td class="xl178" style="border-top:none;border-left:none">-</td> <td class="xl181" style="border-top:none;border-left:none">1</td> <td class="xl176" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl177" style="border-top:none;border-left:none"> PAY084 </td> <td class="xl177" style="border-top:none;border-left:none"> B11 </td> <td class="xl177" style="border-top:none;border-left:none"> BFCD </td> <td class="xl177" style="border-top:none;border-left:none"> 18JA03988232 </td> <td class="xl184" style="border-top:none;border-left:none">1</td> <td class="xl177" style="border-top:none;border-left:none"> JAG98 </td> <td class="xl175" style="border-top:none;border-left:none">BAD</td> <td class="xl175" style="border-top:none;border-left:none">EE01</td> <td class="xl177" style="border-top:none;border-left:none"> MEU04 </td> <td class="xl176" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl179" style="border-top:none;border-left:none">0</td> <td class="xl177" style="border-top:none;border-left:none"> BBB </td> <td class="xl176" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl177" style="border-top:none;border-left:none"> BAD </td> <td class="xl177" style="border-top:none;border-left:none"> Refurbished </td> <td class="xl177" style="border-top:none;border-left:none"> AAA </td> <td class="xl177" style="border-top:none;border-left:none"> CCC </td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl182" style="height:12.0pt;border-top:none" height="16">4</td> <td class="xl183" style="border-top:none;border-left:none">31-May-11</td> <td class="xl176" style="border-top:none;border-left:none">B02</td> <td class="xl180" style="border-top:none;border-left:none">B902887</td> <td class="xl180" style="border-top:none;border-left:none">MBC978339</td> <td class="xl180" style="border-top:none;border-left:none">B001</td> <td class="xl180" style="border-top:none;border-left:none">XXX</td> <td class="xl180" style="border-top:none;border-left:none">CCC</td> <td class="xl176" style="border-top:none;border-left:none">28-Feb-14</td> <td class="xl180" style="border-top:none;border-left:none">Ver 7.1</td> <td class="xl176" style="border-top:none;border-left:none">YYY</td> <td class="xl180" style="border-top:none;border-left:none">I01</td> <td class="xl176" style="border-top:none;border-left:none">E</td> <td class="xl176" style="border-top:none;border-left:none">C</td> <td class="xl176" style="border-top:none;border-left:none">31-May-11</td> <td class="xl176" style="border-top:none;border-left:none">31-May-11</td> <td class="xl178" style="border-top:none;border-left:none">-</td> <td class="xl181" style="border-top:none;border-left:none">1</td> <td class="xl176" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl177" style="border-top:none;border-left:none"> </td> <td class="xl177" style="border-top:none;border-left:none"> </td> <td class="xl177" style="border-top:none;border-left:none"> </td> <td class="xl177" style="border-top:none;border-left:none"> </td> <td class="xl184" style="border-top:none;border-left:none"> </td> <td class="xl177" style="border-top:none;border-left:none"> </td> <td class="xl175" style="border-top:none;border-left:none"> </td> <td class="xl175" style="border-top:none;border-left:none"> </td> <td class="xl177" style="border-top:none;border-left:none"> MEU04 </td> <td class="xl176" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl179" style="border-top:none;border-left:none">0</td> <td class="xl177" style="border-top:none;border-left:none"> BBB </td> <td class="xl176" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl177" style="border-top:none;border-left:none"> </td> <td class="xl177" style="border-top:none;border-left:none"> </td> <td class="xl177" style="border-top:none;border-left:none"> AAA </td> <td class="xl177" style="border-top:none;border-left:none"> CCC </td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl182" style="height:12.0pt;border-top:none" height="16">5</td> <td class="xl183" style="border-top:none;border-left:none">31-May-11</td> <td class="xl176" style="border-top:none;border-left:none">B03</td> <td class="xl180" style="border-top:none;border-left:none">B902883</td> <td class="xl180" style="border-top:none;border-left:none">MCC973920</td> <td class="xl180" style="border-top:none;border-left:none">B003</td> <td class="xl180" style="border-top:none;border-left:none">XXX</td> <td class="xl180" style="border-top:none;border-left:none">DDD</td> <td class="xl176" style="border-top:none;border-left:none">31-Mar-13</td> <td class="xl180" style="border-top:none;border-left:none">Ver 7.1</td> <td class="xl176" style="border-top:none;border-left:none">YYY</td> <td class="xl180" style="border-top:none;border-left:none">I01</td> <td class="xl176" style="border-top:none;border-left:none">R</td> <td class="xl176" style="border-top:none;border-left:none">O</td> <td class="xl176" style="border-top:none;border-left:none">31-May-11</td> <td class="xl176" style="border-top:none;border-left:none">31-May-11</td> <td class="xl178" style="border-top:none;border-left:none">-</td> <td class="xl181" style="border-top:none;border-left:none">1</td> <td class="xl176" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl177" style="border-top:none;border-left:none"> M04PBS </td> <td class="xl177" style="border-top:none;border-left:none"> R06 </td> <td class="xl177" style="border-top:none;border-left:none"> 00FG </td> <td class="xl177" style="border-top:none;border-left:none"> 908BF00328 </td> <td class="xl184" style="border-top:none;border-left:none">1</td> <td class="xl177" style="border-top:none;border-left:none"> NBS67 </td> <td class="xl175" style="border-top:none;border-left:none">BAD</td> <td class="xl175" style="border-top:none;border-left:none">EE01</td> <td class="xl177" style="border-top:none;border-left:none"> MEU04 </td> <td class="xl176" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl179" style="border-top:none;border-left:none">0</td> <td class="xl177" style="border-top:none;border-left:none"> BBB </td> <td class="xl176" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl177" style="border-top:none;border-left:none"> BAD </td> <td class="xl177" style="border-top:none;border-left:none"> Refurbished </td> <td class="xl177" style="border-top:none;border-left:none"> AAA </td> <td class="xl177" style="border-top:none;border-left:none"> CCC </td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl182" style="height:12.0pt;border-top:none" height="16">6</td> <td class="xl183" style="border-top:none;border-left:none">31-May-11</td> <td class="xl176" style="border-top:none;border-left:none">C02</td> <td class="xl180" style="border-top:none;border-left:none">C903998</td> <td class="xl180" style="border-top:none;border-left:none">MCC993026</td> <td class="xl180" style="border-top:none;border-left:none">A009</td> <td class="xl180" style="border-top:none;border-left:none">XXX</td> <td class="xl180" style="border-top:none;border-left:none">DDD</td> <td class="xl176" style="border-top:none;border-left:none">30-Apr-14</td> <td class="xl180" style="border-top:none;border-left:none">Ver 7.2</td> <td class="xl176" style="border-top:none;border-left:none">YYY</td> <td class="xl180" style="border-top:none;border-left:none">I01</td> <td class="xl176" style="border-top:none;border-left:none">E</td> <td class="xl176" style="border-top:none;border-left:none">C</td> <td class="xl176" style="border-top:none;border-left:none">31-May-11</td> <td class="xl176" style="border-top:none;border-left:none">31-May-11</td> <td class="xl178" style="border-top:none;border-left:none">-</td> <td class="xl181" style="border-top:none;border-left:none">1</td> <td class="xl176" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl177" style="border-top:none;border-left:none"> X0P030 </td> <td class="xl177" style="border-top:none;border-left:none"> G37 </td> <td class="xl177" style="border-top:none;border-left:none"> FH </td> <td class="xl177" style="border-top:none;border-left:none"> 04TRS0488332 </td> <td class="xl184" style="border-top:none;border-left:none">1</td> <td class="xl177" style="border-top:none;border-left:none"> SCI89 </td> <td class="xl175" style="border-top:none;border-left:none">GOOD</td> <td class="xl175" style="border-top:none;border-left:none"> </td> <td class="xl177" style="border-top:none;border-left:none"> MEU02 </td> <td class="xl176" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl179" style="border-top:none;border-left:none">0</td> <td class="xl177" style="border-top:none;border-left:none"> BBB </td> <td class="xl176" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl177" style="border-top:none;border-left:none"> GOOD </td> <td class="xl177" style="border-top:none;border-left:none"> Log </td> <td class="xl177" style="border-top:none;border-left:none"> AAA </td> <td class="xl177" style="border-top:none;border-left:none"> CCC </td> </tr> </tbody></table>
Kindly note :
1. data record is always starting in row 9 column A.
2. column need to split are column reason 01, reason 02, reason 03, part name and departing loc delimited by space
3. you can ignore usage qty

and the final result should be as figured below (in sheet2) :

<table border="0" cellpadding="0" cellspacing="0" width="4550"><colgroup><col style="mso-width-source:userset;mso-width-alt:4388; width:90pt" span="2" width="120"> <col style="mso-width-source:userset;mso-width-alt:5120;width:105pt" width="140"> <col style="mso-width-source:userset;mso-width-alt:4388;width:90pt" width="120"> <col style="mso-width-source:userset;mso-width-alt:4461;width:92pt" width="122"> <col style="mso-width-source:userset;mso-width-alt:3766;width:77pt" width="103"> <col style="mso-width-source:userset;mso-width-alt:5412;width:111pt" width="148"> <col style="mso-width-source:userset;mso-width-alt:5339;width:110pt" width="146"> <col style="mso-width-source:userset;mso-width-alt:4608;width:95pt" width="126"> <col style="mso-width-source:userset;mso-width-alt:3693;width:76pt" width="101"> <col style="mso-width-source:userset;mso-width-alt:5120;width:105pt" width="140"> <col style="mso-width-source:userset;mso-width-alt:3730;width:77pt" width="102"> <col style="mso-width-source:userset;mso-width-alt:3840; width:79pt" span="2" width="105"> <col style="mso-width-source:userset;mso-width-alt:4498;width:92pt" width="123"> <col style="mso-width-source:userset;mso-width-alt:4608; width:95pt" span="2" width="126"> <col style="mso-width-source:userset;mso-width-alt:3510;width:72pt" width="96"> <col style="mso-width-source:userset;mso-width-alt:5668;mso-outline-parent: collapsed;width:116pt" width="155"> <col style="mso-width-source:userset;mso-width-alt:3986;width:82pt" width="109"> <col style="mso-width-source:userset;mso-width-alt:4096; width:84pt" span="2" width="112"> <col style="mso-width-source:userset;mso-width-alt:5632;width:116pt" width="154"> <col style="mso-width-source:userset;mso-width-alt:3949;width:81pt" width="108"> <col style="mso-width-source:userset;mso-width-alt:4864;width:100pt" width="133"> <col style="mso-width-source:userset;mso-width-alt:4132;width:85pt" width="113"> <col style="mso-width-source:userset;mso-width-alt:6034;width:124pt" width="165"> <col style="mso-width-source:userset;mso-width-alt:3547;width:73pt" width="97"> <col style="mso-width-source:userset;mso-width-alt:3693;width:76pt" width="101"> <col style="mso-width-source:userset;mso-width-alt:5814;width:119pt" width="159"> <col style="mso-width-source:userset;mso-width-alt:3693;width:76pt" width="101"> <col style="mso-width-source:userset;mso-width-alt:4608;width:95pt" width="126"> <col style="mso-width-source:userset;mso-width-alt:5010;width:103pt" width="137"> <col style="mso-width-source:userset;mso-width-alt:5302;width:109pt" width="145"> <col style="mso-width-source:userset;mso-width-alt:5558;width:114pt" width="152"> <col style="mso-width-source:userset;mso-width-alt:7387;width:152pt" width="202"> </colgroup><tbody><tr style="height:12.0pt" height="16"> <td class="xl168" style="height:12.0pt;width:90pt" width="120" height="16">Company Name</td> <td class="xl168" style="width:90pt" width="120">XXX</td> <td class="xl168" style="width:105pt" width="140">
</td> <td class="xl163" style="width:90pt" width="120">
</td> <td class="xl163" style="width:92pt" width="122">
</td> <td class="xl163" style="width:77pt" width="103">
</td> <td class="xl163" style="width:111pt" width="148">
</td> <td class="xl164" style="width:110pt" width="146">
</td> <td class="xl164" style="width:95pt" width="126">
</td> <td class="xl164" style="width:76pt" width="101">
</td> <td class="xl164" style="width:105pt" width="140">
</td> <td class="xl164" style="width:77pt" width="102">
</td> <td class="xl164" style="width:79pt" width="105">
</td> <td class="xl164" style="width:79pt" width="105">
</td> <td class="xl164" style="width:92pt" width="123">
</td> <td class="xl164" style="width:95pt" width="126">
</td> <td class="xl165" style="width:95pt" width="126">
</td> <td class="xl166" style="width:72pt" width="96">
</td> <td class="xl163" style="width:116pt" width="155">
</td> <td class="xl163" style="width:82pt" width="109">
</td> <td class="xl163" style="width:84pt" width="112">
</td> <td class="xl163" style="width:84pt" width="112">
</td> <td class="xl163" style="width:116pt" width="154">
</td> <td class="xl163" style="width:81pt" width="108">
</td> <td class="xl163" style="width:100pt" width="133">
</td> <td class="xl163" style="width:85pt" width="113">
</td> <td class="xl163" style="width:124pt" width="165">
</td> <td class="xl163" style="width:73pt" width="97">
</td> <td class="xl174" style="width:76pt" width="101">
</td> <td class="xl167" style="width:119pt" width="159">
</td> <td class="xl163" style="width:76pt" width="101">
</td> <td class="xl163" style="width:95pt" width="126">
</td> <td class="xl163" style="width:103pt" width="137">
</td> <td class="xl163" style="width:109pt" width="145">
</td> <td class="xl163" style="width:114pt" width="152">
</td> <td class="xl163" style="width:152pt" width="202">
</td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl168" style="height:12.0pt" height="16">Company Address</td> <td class="xl168">YYY111</td> <td class="xl168">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl165">
</td> <td class="xl166">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl174">
</td> <td class="xl167">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl168" style="height:12.0pt" height="16">Company Address</td> <td class="xl168">YYY222</td> <td class="xl168">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl165">
</td> <td class="xl166">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl174">
</td> <td class="xl167">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl168" style="height:12.0pt" height="16">Company Address</td> <td class="xl168">YYY333</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl165">
</td> <td class="xl166">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl174">
</td> <td class="xl167">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl168" style="height:12.0pt" height="16">Period</td> <td class="xl169">DD/MM/YYYY</td> <td class="xl170">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl165">
</td> <td class="xl166">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl174">
</td> <td class="xl167">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl168" style="height:12.0pt" height="16">
</td> <td class="xl171">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl165">
</td> <td class="xl166">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl174">
</td> <td class="xl167">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> </tr> <tr style="height:12.0pt" height="16"> <td colspan="18" class="xl186" style="height:12.0pt" height="16">Reception Unit</td> <td colspan="13" class="xl186" style="border-left:none">Mechanical Unit</td> <td colspan="5" class="xl186" style="border-left:none">Control Unit</td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl186" style="height:12.0pt;border-top:none" height="16">No.</td> <td class="xl172" style="border-top:none;border-left:none">Arrival Date</td> <td class="xl186" style="border-top:none;border-left:none">Customer Type</td> <td class="xl186" style="border-top:none;border-left:none">Form No. 01</td> <td class="xl186" style="border-top:none;border-left:none">Form No. 02</td> <td class="xl186" style="border-top:none;border-left:none">Unit Type</td> <td class="xl186" style="border-top:none;border-left:none">Item Description</td> <td class="xl186" style="border-top:none;border-left:none">Customer Name</td> <td class="xl186" style="border-top:none;border-left:none">Landing Date</td> <td class="xl186" style="border-top:none;border-left:none">Revision</td> <td class="xl186" style="border-top:none;border-left:none">Issue Reported</td> <td class="xl186" style="border-top:none;border-left:none">Status 01</td> <td class="xl186" style="border-top:none;border-left:none">Status 02</td> <td class="xl186" style="border-top:none;border-left:none">Status 03</td> <td class="xl186" style="border-top:none;border-left:none">Gear Date 01</td> <td class="xl186" style="border-top:none;border-left:none">Gear Date 02</td> <td class="xl172" style="border-top:none;border-left:none">Gear Date 03</td> <td class="xl173" style="border-top:none;border-left:none">Counter</td> <td class="xl172" style="border-top:none;border-left:none">Breaktrough Date</td> <td class="xl186" style="border-top:none;border-left:none">Reason 01</td> <td class="xl186" style="border-top:none;border-left:none">Reason 02</td> <td class="xl186" style="border-top:none;border-left:none">Reason 03</td> <td class="xl186" style="border-top:none;border-left:none">Part Name</td> <td class="xl186" style="border-top:none;border-left:none">Usage Qty</td> <td class="xl186" style="border-top:none;border-left:none">Departing Loc</td> <td class="xl186" style="border-top:none;border-left:none">Sub Status</td> <td class="xl186" style="border-top:none;border-left:none">Sub Status Reason</td> <td class="xl186" style="border-top:none;border-left:none">Entry By</td> <td class="xl175" style="border-top:none;border-left:none">Departing Date</td> <td class="xl173" style="border-top:none;border-left:none">Departing Counter</td> <td class="xl186" style="border-top:none;border-left:none">Remarks</td> <td class="xl186" style="border-top:none;border-left:none">Control Date</td> <td class="xl186" style="border-top:none;border-left:none">Control Status</td> <td class="xl186" style="border-top:none;border-left:none">Control goes to</td> <td class="xl186" style="border-top:none;border-left:none">Control Remarks</td> <td class="xl186" style="border-top:none;border-left:none">Control Additional Notes</td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl183" style="height:12.0pt" height="16">1</td> <td class="xl184" style="border-left:none">31-May-11</td> <td class="xl177" style="border-left:none">A01</td> <td class="xl181" style="border-left:none">A901791</td> <td class="xl181" style="border-left:none">MAC909902</td> <td class="xl181" style="border-left:none">B001</td> <td class="xl181" style="border-left:none">XXX</td> <td class="xl181" style="border-left:none">AAA</td> <td class="xl177" style="border-left:none">31-Jul-13</td> <td class="xl181" style="border-left:none">Ver 7.1</td> <td class="xl177" style="border-left:none">YYY</td> <td class="xl181" style="border-left:none">I01</td> <td class="xl177" style="border-left:none">E </td> <td class="xl177" style="border-left:none">C</td> <td class="xl177" style="border-left:none">30-May-11</td> <td class="xl177" style="border-left:none">30-May-11</td> <td class="xl179" style="border-left:none">-</td> <td class="xl182" style="border-left:none">1</td> <td class="xl177" style="border-left:none">1-Jun-11</td> <td class="xl178" style="border-left:none"> Z00P09 </td> <td class="xl178" style="border-left:none"> R11 </td> <td class="xl178" style="border-left:none"> 00BC </td> <td class="xl178" style="border-left:none"> 07HB10087G </td> <td class="xl185" style="border-left:none">2</td> <td class="xl178" style="border-left:none"> BEN01 </td> <td class="xl176" style="border-left:none">GOOD</td> <td class="xl176" style="border-left:none"> </td> <td class="xl178" style="border-left:none"> MEU02 </td> <td class="xl177" style="border-left:none">1-Jun-11</td> <td class="xl180" style="border-left:none">0</td> <td class="xl178" style="border-left:none"> BBB </td> <td class="xl177" style="border-left:none">1-Jun-11</td> <td class="xl178" style="border-left:none"> GOOD </td> <td class="xl178" style="border-left:none"> Log </td> <td class="xl178" style="border-left:none"> AAA </td> <td class="xl178" style="border-left:none"> CCC </td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl183" style="height:12.0pt;border-top:none" height="16">2</td> <td class="xl184" style="border-top:none;border-left:none">31-May-11</td> <td class="xl177" style="border-top:none;border-left:none">A01</td> <td class="xl181" style="border-top:none;border-left:none">A901791</td> <td class="xl181" style="border-top:none;border-left:none">MAC909902</td> <td class="xl181" style="border-top:none;border-left:none">B001</td> <td align="left" valign="top">
clip_image002.gif
<table cellpadding="0" cellspacing="0"> <tbody><tr> <td class="xl181" style="height:12.0pt;border-top:none; border-left:none;width:111pt" width="148" height="16">XXX</td> </tr> </tbody></table> </td> <td class="xl181" style="border-top:none;border-left:none">AAA</td> <td class="xl177" style="border-top:none;border-left:none">31-Jul-13</td> <td class="xl181" style="border-top:none;border-left:none">Ver 7.1</td> <td class="xl177" style="border-top:none;border-left:none">YYY</td> <td class="xl181" style="border-top:none;border-left:none">I01</td> <td class="xl177" style="border-top:none;border-left:none">E </td> <td class="xl177" style="border-top:none;border-left:none">C</td> <td class="xl177" style="border-top:none;border-left:none">30-May-11</td> <td class="xl177" style="border-top:none;border-left:none">30-May-11</td> <td class="xl179" style="border-top:none;border-left:none">-</td> <td class="xl182" style="border-top:none;border-left:none">1</td> <td class="xl177" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl178" style="border-top:none;border-left:none"> X09Y02 </td> <td class="xl178" style="border-top:none;border-left:none"> E23 </td> <td class="xl178" style="border-top:none;border-left:none"> EF </td> <td class="xl178" style="border-top:none;border-left:none"> 93GII8893 </td> <td class="xl185" style="border-top:none;border-left:none">2</td> <td class="xl178" style="border-top:none;border-left:none"> JHN04 </td> <td class="xl176" style="border-top:none;border-left:none">GOOD</td> <td class="xl176" style="border-top:none;border-left:none"> </td> <td class="xl178" style="border-top:none;border-left:none"> MEU02 </td> <td class="xl177" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl180" style="border-top:none;border-left:none">0</td> <td class="xl178" style="border-top:none;border-left:none"> BBB </td> <td class="xl177" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl178" style="border-top:none;border-left:none"> GOOD </td> <td class="xl178" style="border-top:none;border-left:none"> Log </td> <td class="xl178" style="border-top:none;border-left:none"> AAA </td> <td class="xl178" style="border-top:none;border-left:none"> CCC </td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl183" style="height:12.0pt;border-top:none" height="16">3</td> <td class="xl184" style="border-top:none;border-left:none">31-May-11</td> <td class="xl177" style="border-top:none;border-left:none">A01</td> <td class="xl181" style="border-top:none;border-left:none">A901882</td> <td class="xl181" style="border-top:none;border-left:none">MAC909332</td> <td class="xl181" style="border-top:none;border-left:none">B001</td> <td class="xl181" style="border-top:none;border-left:none">XXX</td> <td class="xl181" style="border-top:none;border-left:none">BBB</td> <td class="xl177" style="border-top:none;border-left:none">31-Dec-13</td> <td class="xl181" style="border-top:none;border-left:none">Ver 8.2</td> <td class="xl177" style="border-top:none;border-left:none">YYY</td> <td class="xl181" style="border-top:none;border-left:none">I01</td> <td class="xl177" style="border-top:none;border-left:none">E</td> <td class="xl177" style="border-top:none;border-left:none">C</td> <td class="xl177" style="border-top:none;border-left:none">31-May-11</td> <td class="xl177" style="border-top:none;border-left:none">31-May-11</td> <td class="xl179" style="border-top:none;border-left:none">-</td> <td class="xl182" style="border-top:none;border-left:none">1</td> <td class="xl177" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl178" style="border-top:none;border-left:none"> X0P030 </td> <td class="xl178" style="border-top:none;border-left:none"> R11 </td> <td class="xl178" style="border-top:none;border-left:none"> GAYY </td> <td class="xl178" style="border-top:none;border-left:none"> 03JJ893392 </td> <td class="xl185" style="border-top:none;border-left:none">2</td> <td class="xl178" style="border-top:none;border-left:none"> SBI55 </td> <td class="xl176" style="border-top:none;border-left:none">GOOD</td> <td class="xl176" style="border-top:none;border-left:none"> </td> <td class="xl178" style="border-top:none;border-left:none"> MEU02 </td> <td class="xl177" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl180" style="border-top:none;border-left:none">0</td> <td class="xl178" style="border-top:none;border-left:none"> BBB </td> <td class="xl177" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl178" style="border-top:none;border-left:none"> GOOD </td> <td class="xl178" style="border-top:none;border-left:none"> Log </td> <td class="xl178" style="border-top:none;border-left:none"> AAA </td> <td class="xl178" style="border-top:none;border-left:none"> CCC </td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl183" style="height:12.0pt;border-top:none" height="16">4</td> <td class="xl184" style="border-top:none;border-left:none">31-May-11</td> <td class="xl177" style="border-top:none;border-left:none">A01</td> <td class="xl181" style="border-top:none;border-left:none">A901882</td> <td class="xl181" style="border-top:none;border-left:none">MAC909332</td> <td class="xl181" style="border-top:none;border-left:none">B001</td> <td class="xl181" style="border-top:none;border-left:none">XXX</td> <td class="xl181" style="border-top:none;border-left:none">BBB</td> <td class="xl177" style="border-top:none;border-left:none">31-Dec-13</td> <td class="xl181" style="border-top:none;border-left:none">Ver 8.2</td> <td class="xl177" style="border-top:none;border-left:none">YYY</td> <td class="xl181" style="border-top:none;border-left:none">I01</td> <td class="xl177" style="border-top:none;border-left:none">E</td> <td class="xl177" style="border-top:none;border-left:none">C</td> <td class="xl177" style="border-top:none;border-left:none">31-May-11</td> <td class="xl177" style="border-top:none;border-left:none">31-May-11</td> <td class="xl179" style="border-top:none;border-left:none">-</td> <td class="xl182" style="border-top:none;border-left:none">1</td> <td class="xl177" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl178" style="border-top:none;border-left:none"> YYA309 </td> <td class="xl178" style="border-top:none;border-left:none"> B32 </td> <td class="xl178" style="border-top:none;border-left:none"> B89F </td> <td class="xl178" style="border-top:none;border-left:none"> 09YYNM09304 </td> <td class="xl185" style="border-top:none;border-left:none">2</td> <td class="xl178" style="border-top:none;border-left:none"> KON77 </td> <td class="xl176" style="border-top:none;border-left:none">GOOD</td> <td class="xl176" style="border-top:none;border-left:none"> </td> <td class="xl178" style="border-top:none;border-left:none"> MEU02 </td> <td class="xl177" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl180" style="border-top:none;border-left:none">0</td> <td class="xl178" style="border-top:none;border-left:none"> BBB </td> <td class="xl177" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl178" style="border-top:none;border-left:none"> GOOD </td> <td class="xl178" style="border-top:none;border-left:none"> Log </td> <td class="xl178" style="border-top:none;border-left:none"> AAA </td> <td class="xl178" style="border-top:none;border-left:none"> CCC </td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl183" style="height:12.0pt;border-top:none" height="16">5</td> <td class="xl184" style="border-top:none;border-left:none">31-May-11</td> <td class="xl177" style="border-top:none;border-left:none">B02</td> <td class="xl181" style="border-top:none;border-left:none">B902920</td> <td class="xl181" style="border-top:none;border-left:none">MBC903234</td> <td class="xl181" style="border-top:none;border-left:none">B002</td> <td class="xl181" style="border-top:none;border-left:none">XXX</td> <td class="xl181" style="border-top:none;border-left:none">CCC</td> <td class="xl177" style="border-top:none;border-left:none">31-Oct-13</td> <td class="xl181" style="border-top:none;border-left:none">Ver 7.1</td> <td class="xl177" style="border-top:none;border-left:none">YYY</td> <td class="xl181" style="border-top:none;border-left:none">I01</td> <td class="xl177" style="border-top:none;border-left:none">E</td> <td class="xl177" style="border-top:none;border-left:none">C</td> <td class="xl177" style="border-top:none;border-left:none">31-May-11</td> <td class="xl177" style="border-top:none;border-left:none">31-May-11</td> <td class="xl179" style="border-top:none;border-left:none">-</td> <td class="xl182" style="border-top:none;border-left:none">1</td> <td class="xl177" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl178" style="border-top:none;border-left:none"> PAY084 </td> <td class="xl178" style="border-top:none;border-left:none"> B11 </td> <td class="xl178" style="border-top:none;border-left:none"> BFCD </td> <td class="xl178" style="border-top:none;border-left:none"> 18JA03988232 </td> <td class="xl185" style="border-top:none;border-left:none">1</td> <td class="xl178" style="border-top:none;border-left:none"> JAG98 </td> <td class="xl176" style="border-top:none;border-left:none">BAD</td> <td class="xl176" style="border-top:none;border-left:none">EE01</td> <td class="xl178" style="border-top:none;border-left:none"> MEU04 </td> <td class="xl177" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl180" style="border-top:none;border-left:none">0</td> <td class="xl178" style="border-top:none;border-left:none"> BBB </td> <td class="xl177" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl178" style="border-top:none;border-left:none"> BAD </td> <td class="xl178" style="border-top:none;border-left:none"> Refurbished </td> <td class="xl178" style="border-top:none;border-left:none"> AAA </td> <td class="xl178" style="border-top:none;border-left:none"> CCC </td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl183" style="height:12.0pt;border-top:none" height="16">6</td> <td class="xl184" style="border-top:none;border-left:none">31-May-11</td> <td class="xl177" style="border-top:none;border-left:none">B02</td> <td class="xl181" style="border-top:none;border-left:none">B902887</td> <td class="xl181" style="border-top:none;border-left:none">MBC978339</td> <td class="xl181" style="border-top:none;border-left:none">B001</td> <td class="xl181" style="border-top:none;border-left:none">XXX</td> <td class="xl181" style="border-top:none;border-left:none">CCC</td> <td class="xl177" style="border-top:none;border-left:none">28-Feb-14</td> <td class="xl181" style="border-top:none;border-left:none">Ver 7.1</td> <td class="xl177" style="border-top:none;border-left:none">YYY</td> <td class="xl181" style="border-top:none;border-left:none">I01</td> <td class="xl177" style="border-top:none;border-left:none">E</td> <td class="xl177" style="border-top:none;border-left:none">C</td> <td class="xl177" style="border-top:none;border-left:none">31-May-11</td> <td class="xl177" style="border-top:none;border-left:none">31-May-11</td> <td class="xl179" style="border-top:none;border-left:none">-</td> <td class="xl182" style="border-top:none;border-left:none">1</td> <td class="xl177" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl178" style="border-top:none;border-left:none"> </td> <td class="xl178" style="border-top:none;border-left:none"> </td> <td class="xl178" style="border-top:none;border-left:none"> </td> <td class="xl178" style="border-top:none;border-left:none"> </td> <td class="xl185" style="border-top:none;border-left:none"> </td> <td class="xl178" style="border-top:none;border-left:none"> </td> <td class="xl176" style="border-top:none;border-left:none"> </td> <td class="xl176" style="border-top:none;border-left:none"> </td> <td class="xl178" style="border-top:none;border-left:none"> MEU04 </td> <td class="xl177" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl180" style="border-top:none;border-left:none">0</td> <td class="xl178" style="border-top:none;border-left:none"> BBB </td> <td class="xl177" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl178" style="border-top:none;border-left:none"> </td> <td class="xl178" style="border-top:none;border-left:none"> </td> <td class="xl178" style="border-top:none;border-left:none"> AAA </td> <td class="xl178" style="border-top:none;border-left:none"> CCC </td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl183" style="height:12.0pt;border-top:none" height="16">7</td> <td class="xl184" style="border-top:none;border-left:none">31-May-11</td> <td class="xl177" style="border-top:none;border-left:none">B03</td> <td class="xl181" style="border-top:none;border-left:none">B902883</td> <td class="xl181" style="border-top:none;border-left:none">MCC973920</td> <td class="xl181" style="border-top:none;border-left:none">B003</td> <td class="xl181" style="border-top:none;border-left:none">XXX</td> <td class="xl181" style="border-top:none;border-left:none">DDD</td> <td class="xl177" style="border-top:none;border-left:none">31-Mar-13</td> <td class="xl181" style="border-top:none;border-left:none">Ver 7.1</td> <td class="xl177" style="border-top:none;border-left:none">YYY</td> <td class="xl181" style="border-top:none;border-left:none">I01</td> <td class="xl177" style="border-top:none;border-left:none">R</td> <td class="xl177" style="border-top:none;border-left:none">O</td> <td class="xl177" style="border-top:none;border-left:none">31-May-11</td> <td class="xl177" style="border-top:none;border-left:none">31-May-11</td> <td class="xl179" style="border-top:none;border-left:none">-</td> <td class="xl182" style="border-top:none;border-left:none">1</td> <td class="xl177" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl178" style="border-top:none;border-left:none"> M04PBS </td> <td class="xl178" style="border-top:none;border-left:none"> R06 </td> <td class="xl178" style="border-top:none;border-left:none"> 00FG </td> <td class="xl178" style="border-top:none;border-left:none"> 908BF00328 </td> <td class="xl185" style="border-top:none;border-left:none">1</td> <td class="xl178" style="border-top:none;border-left:none"> NBS67 </td> <td class="xl176" style="border-top:none;border-left:none">BAD</td> <td class="xl176" style="border-top:none;border-left:none">EE01</td> <td class="xl178" style="border-top:none;border-left:none"> MEU04 </td> <td class="xl177" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl180" style="border-top:none;border-left:none">0</td> <td class="xl178" style="border-top:none;border-left:none"> BBB </td> <td class="xl177" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl178" style="border-top:none;border-left:none"> BAD </td> <td class="xl178" style="border-top:none;border-left:none"> Refurbished </td> <td class="xl178" style="border-top:none;border-left:none"> AAA </td> <td class="xl178" style="border-top:none;border-left:none"> CCC </td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl183" style="height:12.0pt;border-top:none" height="16">8</td> <td class="xl184" style="border-top:none;border-left:none">31-May-11</td> <td class="xl177" style="border-top:none;border-left:none">C02</td> <td class="xl181" style="border-top:none;border-left:none">C903998</td> <td class="xl181" style="border-top:none;border-left:none">MCC993026</td> <td class="xl181" style="border-top:none;border-left:none">A009</td> <td class="xl181" style="border-top:none;border-left:none">XXX</td> <td class="xl181" style="border-top:none;border-left:none">DDD</td> <td class="xl177" style="border-top:none;border-left:none">30-Apr-14</td> <td class="xl181" style="border-top:none;border-left:none">Ver 7.2</td> <td class="xl177" style="border-top:none;border-left:none">YYY</td> <td class="xl181" style="border-top:none;border-left:none">I01</td> <td class="xl177" style="border-top:none;border-left:none">E</td> <td class="xl177" style="border-top:none;border-left:none">C</td> <td class="xl177" style="border-top:none;border-left:none">31-May-11</td> <td class="xl177" style="border-top:none;border-left:none">31-May-11</td> <td class="xl179" style="border-top:none;border-left:none">-</td> <td class="xl182" style="border-top:none;border-left:none">1</td> <td class="xl177" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl178" style="border-top:none;border-left:none"> X0P030 </td> <td class="xl178" style="border-top:none;border-left:none"> G37 </td> <td class="xl178" style="border-top:none;border-left:none"> FH </td> <td class="xl178" style="border-top:none;border-left:none"> 04TRS0488332 </td> <td class="xl185" style="border-top:none;border-left:none">1</td> <td class="xl178" style="border-top:none;border-left:none"> SCI89 </td> <td class="xl176" style="border-top:none;border-left:none">GOOD</td> <td class="xl176" style="border-top:none;border-left:none"> </td> <td class="xl178" style="border-top:none;border-left:none"> MEU02 </td> <td class="xl177" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl180" style="border-top:none;border-left:none">0</td> <td class="xl178" style="border-top:none;border-left:none"> BBB </td> <td class="xl177" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl178" style="border-top:none;border-left:none"> GOOD </td> <td class="xl178" style="border-top:none;border-left:none"> Log </td> <td class="xl178" style="border-top:none;border-left:none"> AAA </td> <td class="xl178" style="border-top:none;border-left:none"> CCC </td> </tr> </tbody></table>
 
Upvote 0

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
Dear mirabeau,

Sorry for bother again, i was trying to modified your macro code, but in the end i got stuck and mess up all the code that you advise to me. and i have no other choice except asking for your help again, but this time i give you my real data format with dummy data.
Please your help and effort again to solve this problem
Thanks a lot in advance

Andy (Elf)

Data as follows (in sheet1) :

<table border="0" cellpadding="0" cellspacing="0" width="4550"><colgroup><col style="mso-width-source:userset;mso-width-alt:4388; width:90pt" span="2" width="120"> <col style="mso-width-source:userset;mso-width-alt:5120;width:105pt" width="140"> <col style="mso-width-source:userset;mso-width-alt:4388;width:90pt" width="120"> <col style="mso-width-source:userset;mso-width-alt:4461;width:92pt" width="122"> <col style="mso-width-source:userset;mso-width-alt:3766;width:77pt" width="103"> <col style="mso-width-source:userset;mso-width-alt:5412;width:111pt" width="148"> <col style="mso-width-source:userset;mso-width-alt:5339;width:110pt" width="146"> <col style="mso-width-source:userset;mso-width-alt:4608;width:95pt" width="126"> <col style="mso-width-source:userset;mso-width-alt:3693;width:76pt" width="101"> <col style="mso-width-source:userset;mso-width-alt:5120;width:105pt" width="140"> <col style="mso-width-source:userset;mso-width-alt:3730;width:77pt" width="102"> <col style="mso-width-source:userset;mso-width-alt:3840; width:79pt" span="2" width="105"> <col style="mso-width-source:userset;mso-width-alt:4498;width:92pt" width="123"> <col style="mso-width-source:userset;mso-width-alt:4608; width:95pt" span="2" width="126"> <col style="mso-width-source:userset;mso-width-alt:3510;width:72pt" width="96"> <col style="mso-width-source:userset;mso-width-alt:5668;mso-outline-parent: collapsed;width:116pt" width="155"> <col style="mso-width-source:userset;mso-width-alt:3986;width:82pt" width="109"> <col style="mso-width-source:userset;mso-width-alt:4096; width:84pt" span="2" width="112"> <col style="mso-width-source:userset;mso-width-alt:5632;width:116pt" width="154"> <col style="mso-width-source:userset;mso-width-alt:3949;width:81pt" width="108"> <col style="mso-width-source:userset;mso-width-alt:4864;width:100pt" width="133"> <col style="mso-width-source:userset;mso-width-alt:4132;width:85pt" width="113"> <col style="mso-width-source:userset;mso-width-alt:6034;width:124pt" width="165"> <col style="mso-width-source:userset;mso-width-alt:3547;width:73pt" width="97"> <col style="mso-width-source:userset;mso-width-alt:3693;width:76pt" width="101"> <col style="mso-width-source:userset;mso-width-alt:5814;width:119pt" width="159"> <col style="mso-width-source:userset;mso-width-alt:3693;width:76pt" width="101"> <col style="mso-width-source:userset;mso-width-alt:4608;width:95pt" width="126"> <col style="mso-width-source:userset;mso-width-alt:5010;width:103pt" width="137"> <col style="mso-width-source:userset;mso-width-alt:5302;width:109pt" width="145"> <col style="mso-width-source:userset;mso-width-alt:5558;width:114pt" width="152"> <col style="mso-width-source:userset;mso-width-alt:7387;width:152pt" width="202"> </colgroup><tbody><tr style="height:12.0pt" height="16"> <td class="xl166" style="height:12.0pt;width:90pt" width="120" height="16">Company Name</td> <td class="xl166" style="width:90pt" width="120">XXX</td> <td class="xl166" style="width:105pt" width="140">
</td> <td class="xl161" style="width:90pt" width="120">
</td> <td class="xl161" style="width:92pt" width="122">
</td> <td class="xl161" style="width:77pt" width="103">
</td> <td class="xl161" style="width:111pt" width="148">
</td> <td class="xl162" style="width:110pt" width="146">
</td> <td class="xl162" style="width:95pt" width="126">
</td> <td class="xl162" style="width:76pt" width="101">
</td> <td class="xl162" style="width:105pt" width="140">
</td> <td class="xl162" style="width:77pt" width="102">
</td> <td class="xl162" style="width:79pt" width="105">
</td> <td class="xl162" style="width:79pt" width="105">
</td> <td class="xl162" style="width:92pt" width="123">
</td> <td class="xl162" style="width:95pt" width="126">
</td> <td class="xl163" style="width:95pt" width="126">
</td> <td class="xl164" style="width:72pt" width="96">
</td> <td class="xl161" style="width:116pt" width="155">
</td> <td class="xl161" style="width:82pt" width="109">
</td> <td class="xl161" style="width:84pt" width="112">
</td> <td class="xl161" style="width:84pt" width="112">
</td> <td class="xl161" style="width:116pt" width="154">
</td> <td class="xl161" style="width:81pt" width="108">
</td> <td class="xl161" style="width:100pt" width="133">
</td> <td class="xl161" style="width:85pt" width="113">
</td> <td class="xl161" style="width:124pt" width="165">
</td> <td class="xl161" style="width:73pt" width="97">
</td> <td class="xl173" style="width:76pt" width="101">
</td> <td class="xl165" style="width:119pt" width="159">
</td> <td class="xl161" style="width:76pt" width="101">
</td> <td class="xl161" style="width:95pt" width="126">
</td> <td class="xl161" style="width:103pt" width="137">
</td> <td class="xl161" style="width:109pt" width="145">
</td> <td class="xl161" style="width:114pt" width="152">
</td> <td class="xl161" style="width:152pt" width="202">
</td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl166" style="height:12.0pt" height="16">Company Address</td> <td class="xl166">YYY111</td> <td class="xl166">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl163">
</td> <td class="xl164">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl173">
</td> <td class="xl165">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl166" style="height:12.0pt" height="16">Company Address</td> <td class="xl166">YYY222</td> <td class="xl166">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl163">
</td> <td class="xl164">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl173">
</td> <td class="xl165">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl166" style="height:12.0pt" height="16">Company Address</td> <td class="xl166">YYY333</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl163">
</td> <td class="xl164">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl173">
</td> <td class="xl165">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl166" style="height:12.0pt" height="16">Period</td> <td class="xl167">DD/MM/YYYY</td> <td class="xl168">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl163">
</td> <td class="xl164">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl173">
</td> <td class="xl165">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl166" style="height:12.0pt" height="16">
</td> <td class="xl169">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl162">
</td> <td class="xl163">
</td> <td class="xl164">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl173">
</td> <td class="xl165">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> <td class="xl161">
</td> </tr> <tr style="height:12.0pt" height="16"> <td colspan="18" class="xl172" style="height:12.0pt" height="16">Reception Unit</td> <td colspan="13" class="xl172" style="border-left:none">Mechanical Unit</td> <td colspan="5" class="xl172" style="border-left:none">Control Unit</td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl172" style="height:12.0pt;border-top:none" height="16">No.</td> <td class="xl170" style="border-top:none;border-left:none">Arrival Date</td> <td class="xl172" style="border-top:none;border-left:none">Customer Type</td> <td class="xl172" style="border-top:none;border-left:none">Form No. 01</td> <td class="xl172" style="border-top:none;border-left:none">Form No. 02</td> <td class="xl172" style="border-top:none;border-left:none">Unit Type</td> <td class="xl172" style="border-top:none;border-left:none">Item Description</td> <td class="xl172" style="border-top:none;border-left:none">Customer Name</td> <td class="xl172" style="border-top:none;border-left:none">Landing Date</td> <td class="xl172" style="border-top:none;border-left:none">Revision</td> <td class="xl172" style="border-top:none;border-left:none">Issue Reported</td> <td class="xl172" style="border-top:none;border-left:none">Status 01</td> <td class="xl172" style="border-top:none;border-left:none">Status 02</td> <td class="xl172" style="border-top:none;border-left:none">Status 03</td> <td class="xl172" style="border-top:none;border-left:none">Gear Date 01</td> <td class="xl172" style="border-top:none;border-left:none">Gear Date 02</td> <td class="xl170" style="border-top:none;border-left:none">Gear Date 03</td> <td class="xl171" style="border-top:none;border-left:none">Counter</td> <td class="xl170" style="border-top:none;border-left:none">Breaktrough Date</td> <td class="xl172" style="border-top:none;border-left:none">Reason 01</td> <td class="xl172" style="border-top:none;border-left:none">Reason 02</td> <td class="xl172" style="border-top:none;border-left:none">Reason 03</td> <td class="xl172" style="border-top:none;border-left:none">Part Name</td> <td class="xl172" style="border-top:none;border-left:none">Usage Qty</td> <td class="xl172" style="border-top:none;border-left:none">Departing Loc</td> <td class="xl172" style="border-top:none;border-left:none">Sub Status</td> <td class="xl172" style="border-top:none;border-left:none">Sub Status Reason</td> <td class="xl172" style="border-top:none;border-left:none">Entry By</td> <td class="xl174" style="border-top:none;border-left:none">Departing Date</td> <td class="xl171" style="border-top:none;border-left:none">Departing Counter</td> <td class="xl172" style="border-top:none;border-left:none">Remarks</td> <td class="xl172" style="border-top:none;border-left:none">Control Date</td> <td class="xl172" style="border-top:none;border-left:none">Control Status</td> <td class="xl172" style="border-top:none;border-left:none">Control goes to</td> <td class="xl172" style="border-top:none;border-left:none">Control Remarks</td> <td class="xl172" style="border-top:none;border-left:none">Control Additional Notes</td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl182" style="height:12.0pt" height="16">1</td> <td class="xl183" style="border-left:none">31-May-11</td> <td class="xl176" style="border-left:none">A01</td> <td class="xl180" style="border-left:none">A901791</td> <td class="xl180" style="border-left:none">MAC909902</td> <td class="xl180" style="border-left:none">B001</td> <td align="left" valign="top">
clip_image002.gif
<table cellpadding="0" cellspacing="0"> <tbody><tr> <td class="xl180" style="height:12.0pt;border-left:none; width:111pt" width="148" height="16">XXX</td> </tr> </tbody></table> </td> <td class="xl180" style="border-left:none">AAA</td> <td class="xl176" style="border-left:none">31-Jul-13</td> <td class="xl180" style="border-left:none">Ver 7.1</td> <td class="xl176" style="border-left:none">YYY</td> <td class="xl180" style="border-left:none">I01</td> <td class="xl176" style="border-left:none">E </td> <td class="xl176" style="border-left:none">C</td> <td class="xl176" style="border-left:none">30-May-11</td> <td class="xl176" style="border-left:none">30-May-11</td> <td class="xl178" style="border-left:none">-</td> <td class="xl181" style="border-left:none">1</td> <td class="xl176" style="border-left:none">1-Jun-11</td> <td class="xl177" style="border-left:none"> Z00P09 X09Y02 </td> <td class="xl177" style="border-left:none"> R11 E23 </td> <td class="xl177" style="border-left:none"> 00BC EF </td> <td class="xl177" style="border-left:none"> 07HB10087G 93GII8893 </td> <td class="xl184" style="border-left:none">2</td> <td class="xl177" style="border-left:none"> BEN01 JHN04 </td> <td class="xl175" style="border-left:none">GOOD</td> <td class="xl175" style="border-left:none"> </td> <td class="xl177" style="border-left:none"> MEU02 </td> <td class="xl176" style="border-left:none">1-Jun-11</td> <td class="xl179" style="border-left:none">0</td> <td class="xl177" style="border-left:none"> BBB </td> <td class="xl176" style="border-left:none">1-Jun-11</td> <td class="xl177" style="border-left:none"> GOOD </td> <td class="xl177" style="border-left:none"> Log </td> <td class="xl177" style="border-left:none"> AAA </td> <td class="xl177" style="border-left:none"> CCC </td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl182" style="height:12.0pt;border-top:none" height="16">2</td> <td class="xl183" style="border-top:none;border-left:none">31-May-11</td> <td class="xl176" style="border-top:none;border-left:none">A01</td> <td class="xl180" style="border-top:none;border-left:none">A901882</td> <td class="xl180" style="border-top:none;border-left:none">MAC909332</td> <td class="xl180" style="border-top:none;border-left:none">B001</td> <td class="xl180" style="border-top:none;border-left:none">XXX</td> <td class="xl180" style="border-top:none;border-left:none">BBB</td> <td class="xl176" style="border-top:none;border-left:none">31-Dec-13</td> <td class="xl180" style="border-top:none;border-left:none">Ver 8.2</td> <td class="xl176" style="border-top:none;border-left:none">YYY</td> <td class="xl180" style="border-top:none;border-left:none">I01</td> <td class="xl176" style="border-top:none;border-left:none">E</td> <td class="xl176" style="border-top:none;border-left:none">C</td> <td class="xl176" style="border-top:none;border-left:none">31-May-11</td> <td class="xl176" style="border-top:none;border-left:none">31-May-11</td> <td class="xl178" style="border-top:none;border-left:none">-</td> <td class="xl181" style="border-top:none;border-left:none">1</td> <td class="xl176" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl177" style="border-top:none;border-left:none"> X0P030 YYA309 </td> <td class="xl177" style="border-top:none;border-left:none"> R11 B32 </td> <td class="xl177" style="border-top:none;border-left:none"> GAYY B89F </td> <td class="xl177" style="border-top:none;border-left:none"> 03JJ893392 09YYNM09304 </td> <td class="xl184" style="border-top:none;border-left:none">2</td> <td class="xl177" style="border-top:none;border-left:none"> SBI55 KON77 </td> <td class="xl175" style="border-top:none;border-left:none">GOOD</td> <td class="xl175" style="border-top:none;border-left:none"> </td> <td class="xl177" style="border-top:none;border-left:none"> MEU02 </td> <td class="xl176" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl179" style="border-top:none;border-left:none">0</td> <td class="xl177" style="border-top:none;border-left:none"> BBB </td> <td class="xl176" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl177" style="border-top:none;border-left:none"> GOOD </td> <td class="xl177" style="border-top:none;border-left:none"> Log </td> <td class="xl177" style="border-top:none;border-left:none"> AAA </td> <td class="xl177" style="border-top:none;border-left:none"> CCC </td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl182" style="height:12.0pt;border-top:none" height="16">3</td> <td class="xl183" style="border-top:none;border-left:none">31-May-11</td> <td class="xl176" style="border-top:none;border-left:none">B02</td> <td class="xl180" style="border-top:none;border-left:none">B902920</td> <td class="xl180" style="border-top:none;border-left:none">MBC903234</td> <td class="xl180" style="border-top:none;border-left:none">B002</td> <td class="xl180" style="border-top:none;border-left:none">XXX</td> <td class="xl180" style="border-top:none;border-left:none">CCC</td> <td class="xl176" style="border-top:none;border-left:none">31-Oct-13</td> <td class="xl180" style="border-top:none;border-left:none">Ver 7.1</td> <td class="xl176" style="border-top:none;border-left:none">YYY</td> <td class="xl180" style="border-top:none;border-left:none">I01</td> <td class="xl176" style="border-top:none;border-left:none">E</td> <td class="xl176" style="border-top:none;border-left:none">C</td> <td class="xl176" style="border-top:none;border-left:none">31-May-11</td> <td class="xl176" style="border-top:none;border-left:none">31-May-11</td> <td class="xl178" style="border-top:none;border-left:none">-</td> <td class="xl181" style="border-top:none;border-left:none">1</td> <td class="xl176" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl177" style="border-top:none;border-left:none"> PAY084 </td> <td class="xl177" style="border-top:none;border-left:none"> B11 </td> <td class="xl177" style="border-top:none;border-left:none"> BFCD </td> <td class="xl177" style="border-top:none;border-left:none"> 18JA03988232 </td> <td class="xl184" style="border-top:none;border-left:none">1</td> <td class="xl177" style="border-top:none;border-left:none"> JAG98 </td> <td class="xl175" style="border-top:none;border-left:none">BAD</td> <td class="xl175" style="border-top:none;border-left:none">EE01</td> <td class="xl177" style="border-top:none;border-left:none"> MEU04 </td> <td class="xl176" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl179" style="border-top:none;border-left:none">0</td> <td class="xl177" style="border-top:none;border-left:none"> BBB </td> <td class="xl176" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl177" style="border-top:none;border-left:none"> BAD </td> <td class="xl177" style="border-top:none;border-left:none"> Refurbished </td> <td class="xl177" style="border-top:none;border-left:none"> AAA </td> <td class="xl177" style="border-top:none;border-left:none"> CCC </td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl182" style="height:12.0pt;border-top:none" height="16">4</td> <td class="xl183" style="border-top:none;border-left:none">31-May-11</td> <td class="xl176" style="border-top:none;border-left:none">B02</td> <td class="xl180" style="border-top:none;border-left:none">B902887</td> <td class="xl180" style="border-top:none;border-left:none">MBC978339</td> <td class="xl180" style="border-top:none;border-left:none">B001</td> <td class="xl180" style="border-top:none;border-left:none">XXX</td> <td class="xl180" style="border-top:none;border-left:none">CCC</td> <td class="xl176" style="border-top:none;border-left:none">28-Feb-14</td> <td class="xl180" style="border-top:none;border-left:none">Ver 7.1</td> <td class="xl176" style="border-top:none;border-left:none">YYY</td> <td class="xl180" style="border-top:none;border-left:none">I01</td> <td class="xl176" style="border-top:none;border-left:none">E</td> <td class="xl176" style="border-top:none;border-left:none">C</td> <td class="xl176" style="border-top:none;border-left:none">31-May-11</td> <td class="xl176" style="border-top:none;border-left:none">31-May-11</td> <td class="xl178" style="border-top:none;border-left:none">-</td> <td class="xl181" style="border-top:none;border-left:none">1</td> <td class="xl176" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl177" style="border-top:none;border-left:none"> </td> <td class="xl177" style="border-top:none;border-left:none"> </td> <td class="xl177" style="border-top:none;border-left:none"> </td> <td class="xl177" style="border-top:none;border-left:none"> </td> <td class="xl184" style="border-top:none;border-left:none"> </td> <td class="xl177" style="border-top:none;border-left:none"> </td> <td class="xl175" style="border-top:none;border-left:none"> </td> <td class="xl175" style="border-top:none;border-left:none"> </td> <td class="xl177" style="border-top:none;border-left:none"> MEU04 </td> <td class="xl176" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl179" style="border-top:none;border-left:none">0</td> <td class="xl177" style="border-top:none;border-left:none"> BBB </td> <td class="xl176" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl177" style="border-top:none;border-left:none"> </td> <td class="xl177" style="border-top:none;border-left:none"> </td> <td class="xl177" style="border-top:none;border-left:none"> AAA </td> <td class="xl177" style="border-top:none;border-left:none"> CCC </td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl182" style="height:12.0pt;border-top:none" height="16">5</td> <td class="xl183" style="border-top:none;border-left:none">31-May-11</td> <td class="xl176" style="border-top:none;border-left:none">B03</td> <td class="xl180" style="border-top:none;border-left:none">B902883</td> <td class="xl180" style="border-top:none;border-left:none">MCC973920</td> <td class="xl180" style="border-top:none;border-left:none">B003</td> <td class="xl180" style="border-top:none;border-left:none">XXX</td> <td class="xl180" style="border-top:none;border-left:none">DDD</td> <td class="xl176" style="border-top:none;border-left:none">31-Mar-13</td> <td class="xl180" style="border-top:none;border-left:none">Ver 7.1</td> <td class="xl176" style="border-top:none;border-left:none">YYY</td> <td class="xl180" style="border-top:none;border-left:none">I01</td> <td class="xl176" style="border-top:none;border-left:none">R</td> <td class="xl176" style="border-top:none;border-left:none">O</td> <td class="xl176" style="border-top:none;border-left:none">31-May-11</td> <td class="xl176" style="border-top:none;border-left:none">31-May-11</td> <td class="xl178" style="border-top:none;border-left:none">-</td> <td class="xl181" style="border-top:none;border-left:none">1</td> <td class="xl176" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl177" style="border-top:none;border-left:none"> M04PBS </td> <td class="xl177" style="border-top:none;border-left:none"> R06 </td> <td class="xl177" style="border-top:none;border-left:none"> 00FG </td> <td class="xl177" style="border-top:none;border-left:none"> 908BF00328 </td> <td class="xl184" style="border-top:none;border-left:none">1</td> <td class="xl177" style="border-top:none;border-left:none"> NBS67 </td> <td class="xl175" style="border-top:none;border-left:none">BAD</td> <td class="xl175" style="border-top:none;border-left:none">EE01</td> <td class="xl177" style="border-top:none;border-left:none"> MEU04 </td> <td class="xl176" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl179" style="border-top:none;border-left:none">0</td> <td class="xl177" style="border-top:none;border-left:none"> BBB </td> <td class="xl176" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl177" style="border-top:none;border-left:none"> BAD </td> <td class="xl177" style="border-top:none;border-left:none"> Refurbished </td> <td class="xl177" style="border-top:none;border-left:none"> AAA </td> <td class="xl177" style="border-top:none;border-left:none"> CCC </td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl182" style="height:12.0pt;border-top:none" height="16">6</td> <td class="xl183" style="border-top:none;border-left:none">31-May-11</td> <td class="xl176" style="border-top:none;border-left:none">C02</td> <td class="xl180" style="border-top:none;border-left:none">C903998</td> <td class="xl180" style="border-top:none;border-left:none">MCC993026</td> <td class="xl180" style="border-top:none;border-left:none">A009</td> <td class="xl180" style="border-top:none;border-left:none">XXX</td> <td class="xl180" style="border-top:none;border-left:none">DDD</td> <td class="xl176" style="border-top:none;border-left:none">30-Apr-14</td> <td class="xl180" style="border-top:none;border-left:none">Ver 7.2</td> <td class="xl176" style="border-top:none;border-left:none">YYY</td> <td class="xl180" style="border-top:none;border-left:none">I01</td> <td class="xl176" style="border-top:none;border-left:none">E</td> <td class="xl176" style="border-top:none;border-left:none">C</td> <td class="xl176" style="border-top:none;border-left:none">31-May-11</td> <td class="xl176" style="border-top:none;border-left:none">31-May-11</td> <td class="xl178" style="border-top:none;border-left:none">-</td> <td class="xl181" style="border-top:none;border-left:none">1</td> <td class="xl176" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl177" style="border-top:none;border-left:none"> X0P030 </td> <td class="xl177" style="border-top:none;border-left:none"> G37 </td> <td class="xl177" style="border-top:none;border-left:none"> FH </td> <td class="xl177" style="border-top:none;border-left:none"> 04TRS0488332 </td> <td class="xl184" style="border-top:none;border-left:none">1</td> <td class="xl177" style="border-top:none;border-left:none"> SCI89 </td> <td class="xl175" style="border-top:none;border-left:none">GOOD</td> <td class="xl175" style="border-top:none;border-left:none"> </td> <td class="xl177" style="border-top:none;border-left:none"> MEU02 </td> <td class="xl176" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl179" style="border-top:none;border-left:none">0</td> <td class="xl177" style="border-top:none;border-left:none"> BBB </td> <td class="xl176" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl177" style="border-top:none;border-left:none"> GOOD </td> <td class="xl177" style="border-top:none;border-left:none"> Log </td> <td class="xl177" style="border-top:none;border-left:none"> AAA </td> <td class="xl177" style="border-top:none;border-left:none"> CCC </td> </tr> </tbody></table>
Kindly note :
1. data record is always starting in row 9 column A.
2. column need to split are column reason 01 (T), reason 02 (U), reason 03 (V), part name (W) and departing loc (Y) delimited by space
3. you can ignore usage qty (X)

and the final result should be as figured below (in sheet2) :

<table border="0" cellpadding="0" cellspacing="0" width="4550"><colgroup><col style="mso-width-source:userset;mso-width-alt:4388; width:90pt" span="2" width="120"> <col style="mso-width-source:userset;mso-width-alt:5120;width:105pt" width="140"> <col style="mso-width-source:userset;mso-width-alt:4388;width:90pt" width="120"> <col style="mso-width-source:userset;mso-width-alt:4461;width:92pt" width="122"> <col style="mso-width-source:userset;mso-width-alt:3766;width:77pt" width="103"> <col style="mso-width-source:userset;mso-width-alt:5412;width:111pt" width="148"> <col style="mso-width-source:userset;mso-width-alt:5339;width:110pt" width="146"> <col style="mso-width-source:userset;mso-width-alt:4608;width:95pt" width="126"> <col style="mso-width-source:userset;mso-width-alt:3693;width:76pt" width="101"> <col style="mso-width-source:userset;mso-width-alt:5120;width:105pt" width="140"> <col style="mso-width-source:userset;mso-width-alt:3730;width:77pt" width="102"> <col style="mso-width-source:userset;mso-width-alt:3840; width:79pt" span="2" width="105"> <col style="mso-width-source:userset;mso-width-alt:4498;width:92pt" width="123"> <col style="mso-width-source:userset;mso-width-alt:4608; width:95pt" span="2" width="126"> <col style="mso-width-source:userset;mso-width-alt:3510;width:72pt" width="96"> <col style="mso-width-source:userset;mso-width-alt:5668;mso-outline-parent: collapsed;width:116pt" width="155"> <col style="mso-width-source:userset;mso-width-alt:3986;width:82pt" width="109"> <col style="mso-width-source:userset;mso-width-alt:4096; width:84pt" span="2" width="112"> <col style="mso-width-source:userset;mso-width-alt:5632;width:116pt" width="154"> <col style="mso-width-source:userset;mso-width-alt:3949;width:81pt" width="108"> <col style="mso-width-source:userset;mso-width-alt:4864;width:100pt" width="133"> <col style="mso-width-source:userset;mso-width-alt:4132;width:85pt" width="113"> <col style="mso-width-source:userset;mso-width-alt:6034;width:124pt" width="165"> <col style="mso-width-source:userset;mso-width-alt:3547;width:73pt" width="97"> <col style="mso-width-source:userset;mso-width-alt:3693;width:76pt" width="101"> <col style="mso-width-source:userset;mso-width-alt:5814;width:119pt" width="159"> <col style="mso-width-source:userset;mso-width-alt:3693;width:76pt" width="101"> <col style="mso-width-source:userset;mso-width-alt:4608;width:95pt" width="126"> <col style="mso-width-source:userset;mso-width-alt:5010;width:103pt" width="137"> <col style="mso-width-source:userset;mso-width-alt:5302;width:109pt" width="145"> <col style="mso-width-source:userset;mso-width-alt:5558;width:114pt" width="152"> <col style="mso-width-source:userset;mso-width-alt:7387;width:152pt" width="202"> </colgroup><tbody><tr style="height:12.0pt" height="16"> <td class="xl168" style="height:12.0pt;width:90pt" width="120" height="16">Company Name</td> <td class="xl168" style="width:90pt" width="120">XXX</td> <td class="xl168" style="width:105pt" width="140">
</td> <td class="xl163" style="width:90pt" width="120">
</td> <td class="xl163" style="width:92pt" width="122">
</td> <td class="xl163" style="width:77pt" width="103">
</td> <td class="xl163" style="width:111pt" width="148">
</td> <td class="xl164" style="width:110pt" width="146">
</td> <td class="xl164" style="width:95pt" width="126">
</td> <td class="xl164" style="width:76pt" width="101">
</td> <td class="xl164" style="width:105pt" width="140">
</td> <td class="xl164" style="width:77pt" width="102">
</td> <td class="xl164" style="width:79pt" width="105">
</td> <td class="xl164" style="width:79pt" width="105">
</td> <td class="xl164" style="width:92pt" width="123">
</td> <td class="xl164" style="width:95pt" width="126">
</td> <td class="xl165" style="width:95pt" width="126">
</td> <td class="xl166" style="width:72pt" width="96">
</td> <td class="xl163" style="width:116pt" width="155">
</td> <td class="xl163" style="width:82pt" width="109">
</td> <td class="xl163" style="width:84pt" width="112">
</td> <td class="xl163" style="width:84pt" width="112">
</td> <td class="xl163" style="width:116pt" width="154">
</td> <td class="xl163" style="width:81pt" width="108">
</td> <td class="xl163" style="width:100pt" width="133">
</td> <td class="xl163" style="width:85pt" width="113">
</td> <td class="xl163" style="width:124pt" width="165">
</td> <td class="xl163" style="width:73pt" width="97">
</td> <td class="xl174" style="width:76pt" width="101">
</td> <td class="xl167" style="width:119pt" width="159">
</td> <td class="xl163" style="width:76pt" width="101">
</td> <td class="xl163" style="width:95pt" width="126">
</td> <td class="xl163" style="width:103pt" width="137">
</td> <td class="xl163" style="width:109pt" width="145">
</td> <td class="xl163" style="width:114pt" width="152">
</td> <td class="xl163" style="width:152pt" width="202">
</td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl168" style="height:12.0pt" height="16">Company Address</td> <td class="xl168">YYY111</td> <td class="xl168">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl165">
</td> <td class="xl166">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl174">
</td> <td class="xl167">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl168" style="height:12.0pt" height="16">Company Address</td> <td class="xl168">YYY222</td> <td class="xl168">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl165">
</td> <td class="xl166">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl174">
</td> <td class="xl167">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl168" style="height:12.0pt" height="16">Company Address</td> <td class="xl168">YYY333</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl165">
</td> <td class="xl166">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl174">
</td> <td class="xl167">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl168" style="height:12.0pt" height="16">Period</td> <td class="xl169">DD/MM/YYYY</td> <td class="xl170">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl165">
</td> <td class="xl166">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl174">
</td> <td class="xl167">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl168" style="height:12.0pt" height="16">
</td> <td class="xl171">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl164">
</td> <td class="xl165">
</td> <td class="xl166">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl174">
</td> <td class="xl167">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> <td class="xl163">
</td> </tr> <tr style="height:12.0pt" height="16"> <td colspan="18" class="xl186" style="height:12.0pt" height="16">Reception Unit</td> <td colspan="13" class="xl186" style="border-left:none">Mechanical Unit</td> <td colspan="5" class="xl186" style="border-left:none">Control Unit</td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl186" style="height:12.0pt;border-top:none" height="16">No.</td> <td class="xl172" style="border-top:none;border-left:none">Arrival Date</td> <td class="xl186" style="border-top:none;border-left:none">Customer Type</td> <td class="xl186" style="border-top:none;border-left:none">Form No. 01</td> <td class="xl186" style="border-top:none;border-left:none">Form No. 02</td> <td class="xl186" style="border-top:none;border-left:none">Unit Type</td> <td class="xl186" style="border-top:none;border-left:none">Item Description</td> <td class="xl186" style="border-top:none;border-left:none">Customer Name</td> <td class="xl186" style="border-top:none;border-left:none">Landing Date</td> <td class="xl186" style="border-top:none;border-left:none">Revision</td> <td class="xl186" style="border-top:none;border-left:none">Issue Reported</td> <td class="xl186" style="border-top:none;border-left:none">Status 01</td> <td class="xl186" style="border-top:none;border-left:none">Status 02</td> <td class="xl186" style="border-top:none;border-left:none">Status 03</td> <td class="xl186" style="border-top:none;border-left:none">Gear Date 01</td> <td class="xl186" style="border-top:none;border-left:none">Gear Date 02</td> <td class="xl172" style="border-top:none;border-left:none">Gear Date 03</td> <td class="xl173" style="border-top:none;border-left:none">Counter</td> <td class="xl172" style="border-top:none;border-left:none">Breaktrough Date</td> <td class="xl186" style="border-top:none;border-left:none">Reason 01</td> <td class="xl186" style="border-top:none;border-left:none">Reason 02</td> <td class="xl186" style="border-top:none;border-left:none">Reason 03</td> <td class="xl186" style="border-top:none;border-left:none">Part Name</td> <td class="xl186" style="border-top:none;border-left:none">Usage Qty</td> <td class="xl186" style="border-top:none;border-left:none">Departing Loc</td> <td class="xl186" style="border-top:none;border-left:none">Sub Status</td> <td class="xl186" style="border-top:none;border-left:none">Sub Status Reason</td> <td class="xl186" style="border-top:none;border-left:none">Entry By</td> <td class="xl175" style="border-top:none;border-left:none">Departing Date</td> <td class="xl173" style="border-top:none;border-left:none">Departing Counter</td> <td class="xl186" style="border-top:none;border-left:none">Remarks</td> <td class="xl186" style="border-top:none;border-left:none">Control Date</td> <td class="xl186" style="border-top:none;border-left:none">Control Status</td> <td class="xl186" style="border-top:none;border-left:none">Control goes to</td> <td class="xl186" style="border-top:none;border-left:none">Control Remarks</td> <td class="xl186" style="border-top:none;border-left:none">Control Additional Notes</td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl183" style="height:12.0pt" height="16">1</td> <td class="xl184" style="border-left:none">31-May-11</td> <td class="xl177" style="border-left:none">A01</td> <td class="xl181" style="border-left:none">A901791</td> <td class="xl181" style="border-left:none">MAC909902</td> <td class="xl181" style="border-left:none">B001</td> <td class="xl181" style="border-left:none">XXX</td> <td class="xl181" style="border-left:none">AAA</td> <td class="xl177" style="border-left:none">31-Jul-13</td> <td class="xl181" style="border-left:none">Ver 7.1</td> <td class="xl177" style="border-left:none">YYY</td> <td class="xl181" style="border-left:none">I01</td> <td class="xl177" style="border-left:none">E </td> <td class="xl177" style="border-left:none">C</td> <td class="xl177" style="border-left:none">30-May-11</td> <td class="xl177" style="border-left:none">30-May-11</td> <td class="xl179" style="border-left:none">-</td> <td class="xl182" style="border-left:none">1</td> <td class="xl177" style="border-left:none">1-Jun-11</td> <td class="xl178" style="border-left:none"> Z00P09 </td> <td class="xl178" style="border-left:none"> R11 </td> <td class="xl178" style="border-left:none"> 00BC </td> <td class="xl178" style="border-left:none"> 07HB10087G </td> <td class="xl185" style="border-left:none">2</td> <td class="xl178" style="border-left:none"> BEN01 </td> <td class="xl176" style="border-left:none">GOOD</td> <td class="xl176" style="border-left:none"> </td> <td class="xl178" style="border-left:none"> MEU02 </td> <td class="xl177" style="border-left:none">1-Jun-11</td> <td class="xl180" style="border-left:none">0</td> <td class="xl178" style="border-left:none"> BBB </td> <td class="xl177" style="border-left:none">1-Jun-11</td> <td class="xl178" style="border-left:none"> GOOD </td> <td class="xl178" style="border-left:none"> Log </td> <td class="xl178" style="border-left:none"> AAA </td> <td class="xl178" style="border-left:none"> CCC </td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl183" style="height:12.0pt;border-top:none" height="16">2</td> <td class="xl184" style="border-top:none;border-left:none">31-May-11</td> <td class="xl177" style="border-top:none;border-left:none">A01</td> <td class="xl181" style="border-top:none;border-left:none">A901791</td> <td class="xl181" style="border-top:none;border-left:none">MAC909902</td> <td class="xl181" style="border-top:none;border-left:none">B001</td> <td align="left" valign="top">
clip_image002.gif
<table cellpadding="0" cellspacing="0"> <tbody><tr> <td class="xl181" style="height:12.0pt;border-top:none; border-left:none;width:111pt" width="148" height="16">XXX</td> </tr> </tbody></table> </td> <td class="xl181" style="border-top:none;border-left:none">AAA</td> <td class="xl177" style="border-top:none;border-left:none">31-Jul-13</td> <td class="xl181" style="border-top:none;border-left:none">Ver 7.1</td> <td class="xl177" style="border-top:none;border-left:none">YYY</td> <td class="xl181" style="border-top:none;border-left:none">I01</td> <td class="xl177" style="border-top:none;border-left:none">E </td> <td class="xl177" style="border-top:none;border-left:none">C</td> <td class="xl177" style="border-top:none;border-left:none">30-May-11</td> <td class="xl177" style="border-top:none;border-left:none">30-May-11</td> <td class="xl179" style="border-top:none;border-left:none">-</td> <td class="xl182" style="border-top:none;border-left:none">1</td> <td class="xl177" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl178" style="border-top:none;border-left:none"> X09Y02 </td> <td class="xl178" style="border-top:none;border-left:none"> E23 </td> <td class="xl178" style="border-top:none;border-left:none"> EF </td> <td class="xl178" style="border-top:none;border-left:none"> 93GII8893 </td> <td class="xl185" style="border-top:none;border-left:none">2</td> <td class="xl178" style="border-top:none;border-left:none"> JHN04 </td> <td class="xl176" style="border-top:none;border-left:none">GOOD</td> <td class="xl176" style="border-top:none;border-left:none"> </td> <td class="xl178" style="border-top:none;border-left:none"> MEU02 </td> <td class="xl177" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl180" style="border-top:none;border-left:none">0</td> <td class="xl178" style="border-top:none;border-left:none"> BBB </td> <td class="xl177" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl178" style="border-top:none;border-left:none"> GOOD </td> <td class="xl178" style="border-top:none;border-left:none"> Log </td> <td class="xl178" style="border-top:none;border-left:none"> AAA </td> <td class="xl178" style="border-top:none;border-left:none"> CCC </td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl183" style="height:12.0pt;border-top:none" height="16">3</td> <td class="xl184" style="border-top:none;border-left:none">31-May-11</td> <td class="xl177" style="border-top:none;border-left:none">A01</td> <td class="xl181" style="border-top:none;border-left:none">A901882</td> <td class="xl181" style="border-top:none;border-left:none">MAC909332</td> <td class="xl181" style="border-top:none;border-left:none">B001</td> <td class="xl181" style="border-top:none;border-left:none">XXX</td> <td class="xl181" style="border-top:none;border-left:none">BBB</td> <td class="xl177" style="border-top:none;border-left:none">31-Dec-13</td> <td class="xl181" style="border-top:none;border-left:none">Ver 8.2</td> <td class="xl177" style="border-top:none;border-left:none">YYY</td> <td class="xl181" style="border-top:none;border-left:none">I01</td> <td class="xl177" style="border-top:none;border-left:none">E</td> <td class="xl177" style="border-top:none;border-left:none">C</td> <td class="xl177" style="border-top:none;border-left:none">31-May-11</td> <td class="xl177" style="border-top:none;border-left:none">31-May-11</td> <td class="xl179" style="border-top:none;border-left:none">-</td> <td class="xl182" style="border-top:none;border-left:none">1</td> <td class="xl177" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl178" style="border-top:none;border-left:none"> X0P030 </td> <td class="xl178" style="border-top:none;border-left:none"> R11 </td> <td class="xl178" style="border-top:none;border-left:none"> GAYY </td> <td class="xl178" style="border-top:none;border-left:none"> 03JJ893392 </td> <td class="xl185" style="border-top:none;border-left:none">2</td> <td class="xl178" style="border-top:none;border-left:none"> SBI55 </td> <td class="xl176" style="border-top:none;border-left:none">GOOD</td> <td class="xl176" style="border-top:none;border-left:none"> </td> <td class="xl178" style="border-top:none;border-left:none"> MEU02 </td> <td class="xl177" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl180" style="border-top:none;border-left:none">0</td> <td class="xl178" style="border-top:none;border-left:none"> BBB </td> <td class="xl177" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl178" style="border-top:none;border-left:none"> GOOD </td> <td class="xl178" style="border-top:none;border-left:none"> Log </td> <td class="xl178" style="border-top:none;border-left:none"> AAA </td> <td class="xl178" style="border-top:none;border-left:none"> CCC </td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl183" style="height:12.0pt;border-top:none" height="16">4</td> <td class="xl184" style="border-top:none;border-left:none">31-May-11</td> <td class="xl177" style="border-top:none;border-left:none">A01</td> <td class="xl181" style="border-top:none;border-left:none">A901882</td> <td class="xl181" style="border-top:none;border-left:none">MAC909332</td> <td class="xl181" style="border-top:none;border-left:none">B001</td> <td class="xl181" style="border-top:none;border-left:none">XXX</td> <td class="xl181" style="border-top:none;border-left:none">BBB</td> <td class="xl177" style="border-top:none;border-left:none">31-Dec-13</td> <td class="xl181" style="border-top:none;border-left:none">Ver 8.2</td> <td class="xl177" style="border-top:none;border-left:none">YYY</td> <td class="xl181" style="border-top:none;border-left:none">I01</td> <td class="xl177" style="border-top:none;border-left:none">E</td> <td class="xl177" style="border-top:none;border-left:none">C</td> <td class="xl177" style="border-top:none;border-left:none">31-May-11</td> <td class="xl177" style="border-top:none;border-left:none">31-May-11</td> <td class="xl179" style="border-top:none;border-left:none">-</td> <td class="xl182" style="border-top:none;border-left:none">1</td> <td class="xl177" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl178" style="border-top:none;border-left:none"> YYA309 </td> <td class="xl178" style="border-top:none;border-left:none"> B32 </td> <td class="xl178" style="border-top:none;border-left:none"> B89F </td> <td class="xl178" style="border-top:none;border-left:none"> 09YYNM09304 </td> <td class="xl185" style="border-top:none;border-left:none">2</td> <td class="xl178" style="border-top:none;border-left:none"> KON77 </td> <td class="xl176" style="border-top:none;border-left:none">GOOD</td> <td class="xl176" style="border-top:none;border-left:none"> </td> <td class="xl178" style="border-top:none;border-left:none"> MEU02 </td> <td class="xl177" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl180" style="border-top:none;border-left:none">0</td> <td class="xl178" style="border-top:none;border-left:none"> BBB </td> <td class="xl177" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl178" style="border-top:none;border-left:none"> GOOD </td> <td class="xl178" style="border-top:none;border-left:none"> Log </td> <td class="xl178" style="border-top:none;border-left:none"> AAA </td> <td class="xl178" style="border-top:none;border-left:none"> CCC </td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl183" style="height:12.0pt;border-top:none" height="16">5</td> <td class="xl184" style="border-top:none;border-left:none">31-May-11</td> <td class="xl177" style="border-top:none;border-left:none">B02</td> <td class="xl181" style="border-top:none;border-left:none">B902920</td> <td class="xl181" style="border-top:none;border-left:none">MBC903234</td> <td class="xl181" style="border-top:none;border-left:none">B002</td> <td class="xl181" style="border-top:none;border-left:none">XXX</td> <td class="xl181" style="border-top:none;border-left:none">CCC</td> <td class="xl177" style="border-top:none;border-left:none">31-Oct-13</td> <td class="xl181" style="border-top:none;border-left:none">Ver 7.1</td> <td class="xl177" style="border-top:none;border-left:none">YYY</td> <td class="xl181" style="border-top:none;border-left:none">I01</td> <td class="xl177" style="border-top:none;border-left:none">E</td> <td class="xl177" style="border-top:none;border-left:none">C</td> <td class="xl177" style="border-top:none;border-left:none">31-May-11</td> <td class="xl177" style="border-top:none;border-left:none">31-May-11</td> <td class="xl179" style="border-top:none;border-left:none">-</td> <td class="xl182" style="border-top:none;border-left:none">1</td> <td class="xl177" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl178" style="border-top:none;border-left:none"> PAY084 </td> <td class="xl178" style="border-top:none;border-left:none"> B11 </td> <td class="xl178" style="border-top:none;border-left:none"> BFCD </td> <td class="xl178" style="border-top:none;border-left:none"> 18JA03988232 </td> <td class="xl185" style="border-top:none;border-left:none">1</td> <td class="xl178" style="border-top:none;border-left:none"> JAG98 </td> <td class="xl176" style="border-top:none;border-left:none">BAD</td> <td class="xl176" style="border-top:none;border-left:none">EE01</td> <td class="xl178" style="border-top:none;border-left:none"> MEU04 </td> <td class="xl177" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl180" style="border-top:none;border-left:none">0</td> <td class="xl178" style="border-top:none;border-left:none"> BBB </td> <td class="xl177" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl178" style="border-top:none;border-left:none"> BAD </td> <td class="xl178" style="border-top:none;border-left:none"> Refurbished </td> <td class="xl178" style="border-top:none;border-left:none"> AAA </td> <td class="xl178" style="border-top:none;border-left:none"> CCC </td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl183" style="height:12.0pt;border-top:none" height="16">6</td> <td class="xl184" style="border-top:none;border-left:none">31-May-11</td> <td class="xl177" style="border-top:none;border-left:none">B02</td> <td class="xl181" style="border-top:none;border-left:none">B902887</td> <td class="xl181" style="border-top:none;border-left:none">MBC978339</td> <td class="xl181" style="border-top:none;border-left:none">B001</td> <td class="xl181" style="border-top:none;border-left:none">XXX</td> <td class="xl181" style="border-top:none;border-left:none">CCC</td> <td class="xl177" style="border-top:none;border-left:none">28-Feb-14</td> <td class="xl181" style="border-top:none;border-left:none">Ver 7.1</td> <td class="xl177" style="border-top:none;border-left:none">YYY</td> <td class="xl181" style="border-top:none;border-left:none">I01</td> <td class="xl177" style="border-top:none;border-left:none">E</td> <td class="xl177" style="border-top:none;border-left:none">C</td> <td class="xl177" style="border-top:none;border-left:none">31-May-11</td> <td class="xl177" style="border-top:none;border-left:none">31-May-11</td> <td class="xl179" style="border-top:none;border-left:none">-</td> <td class="xl182" style="border-top:none;border-left:none">1</td> <td class="xl177" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl178" style="border-top:none;border-left:none"> </td> <td class="xl178" style="border-top:none;border-left:none"> </td> <td class="xl178" style="border-top:none;border-left:none"> </td> <td class="xl178" style="border-top:none;border-left:none"> </td> <td class="xl185" style="border-top:none;border-left:none"> </td> <td class="xl178" style="border-top:none;border-left:none"> </td> <td class="xl176" style="border-top:none;border-left:none"> </td> <td class="xl176" style="border-top:none;border-left:none"> </td> <td class="xl178" style="border-top:none;border-left:none"> MEU04 </td> <td class="xl177" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl180" style="border-top:none;border-left:none">0</td> <td class="xl178" style="border-top:none;border-left:none"> BBB </td> <td class="xl177" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl178" style="border-top:none;border-left:none"> </td> <td class="xl178" style="border-top:none;border-left:none"> </td> <td class="xl178" style="border-top:none;border-left:none"> AAA </td> <td class="xl178" style="border-top:none;border-left:none"> CCC </td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl183" style="height:12.0pt;border-top:none" height="16">7</td> <td class="xl184" style="border-top:none;border-left:none">31-May-11</td> <td class="xl177" style="border-top:none;border-left:none">B03</td> <td class="xl181" style="border-top:none;border-left:none">B902883</td> <td class="xl181" style="border-top:none;border-left:none">MCC973920</td> <td class="xl181" style="border-top:none;border-left:none">B003</td> <td class="xl181" style="border-top:none;border-left:none">XXX</td> <td class="xl181" style="border-top:none;border-left:none">DDD</td> <td class="xl177" style="border-top:none;border-left:none">31-Mar-13</td> <td class="xl181" style="border-top:none;border-left:none">Ver 7.1</td> <td class="xl177" style="border-top:none;border-left:none">YYY</td> <td class="xl181" style="border-top:none;border-left:none">I01</td> <td class="xl177" style="border-top:none;border-left:none">R</td> <td class="xl177" style="border-top:none;border-left:none">O</td> <td class="xl177" style="border-top:none;border-left:none">31-May-11</td> <td class="xl177" style="border-top:none;border-left:none">31-May-11</td> <td class="xl179" style="border-top:none;border-left:none">-</td> <td class="xl182" style="border-top:none;border-left:none">1</td> <td class="xl177" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl178" style="border-top:none;border-left:none"> M04PBS </td> <td class="xl178" style="border-top:none;border-left:none"> R06 </td> <td class="xl178" style="border-top:none;border-left:none"> 00FG </td> <td class="xl178" style="border-top:none;border-left:none"> 908BF00328 </td> <td class="xl185" style="border-top:none;border-left:none">1</td> <td class="xl178" style="border-top:none;border-left:none"> NBS67 </td> <td class="xl176" style="border-top:none;border-left:none">BAD</td> <td class="xl176" style="border-top:none;border-left:none">EE01</td> <td class="xl178" style="border-top:none;border-left:none"> MEU04 </td> <td class="xl177" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl180" style="border-top:none;border-left:none">0</td> <td class="xl178" style="border-top:none;border-left:none"> BBB </td> <td class="xl177" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl178" style="border-top:none;border-left:none"> BAD </td> <td class="xl178" style="border-top:none;border-left:none"> Refurbished </td> <td class="xl178" style="border-top:none;border-left:none"> AAA </td> <td class="xl178" style="border-top:none;border-left:none"> CCC </td> </tr> <tr style="height:12.0pt" height="16"> <td class="xl183" style="height:12.0pt;border-top:none" height="16">8</td> <td class="xl184" style="border-top:none;border-left:none">31-May-11</td> <td class="xl177" style="border-top:none;border-left:none">C02</td> <td class="xl181" style="border-top:none;border-left:none">C903998</td> <td class="xl181" style="border-top:none;border-left:none">MCC993026</td> <td class="xl181" style="border-top:none;border-left:none">A009</td> <td class="xl181" style="border-top:none;border-left:none">XXX</td> <td class="xl181" style="border-top:none;border-left:none">DDD</td> <td class="xl177" style="border-top:none;border-left:none">30-Apr-14</td> <td class="xl181" style="border-top:none;border-left:none">Ver 7.2</td> <td class="xl177" style="border-top:none;border-left:none">YYY</td> <td class="xl181" style="border-top:none;border-left:none">I01</td> <td class="xl177" style="border-top:none;border-left:none">E</td> <td class="xl177" style="border-top:none;border-left:none">C</td> <td class="xl177" style="border-top:none;border-left:none">31-May-11</td> <td class="xl177" style="border-top:none;border-left:none">31-May-11</td> <td class="xl179" style="border-top:none;border-left:none">-</td> <td class="xl182" style="border-top:none;border-left:none">1</td> <td class="xl177" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl178" style="border-top:none;border-left:none"> X0P030 </td> <td class="xl178" style="border-top:none;border-left:none"> G37 </td> <td class="xl178" style="border-top:none;border-left:none"> FH </td> <td class="xl178" style="border-top:none;border-left:none"> 04TRS0488332 </td> <td class="xl185" style="border-top:none;border-left:none">1</td> <td class="xl178" style="border-top:none;border-left:none"> SCI89 </td> <td class="xl176" style="border-top:none;border-left:none">GOOD</td> <td class="xl176" style="border-top:none;border-left:none"> </td> <td class="xl178" style="border-top:none;border-left:none"> MEU02 </td> <td class="xl177" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl180" style="border-top:none;border-left:none">0</td> <td class="xl178" style="border-top:none;border-left:none"> BBB </td> <td class="xl177" style="border-top:none;border-left:none">1-Jun-11</td> <td class="xl178" style="border-top:none;border-left:none"> GOOD </td> <td class="xl178" style="border-top:none;border-left:none"> Log </td> <td class="xl178" style="border-top:none;border-left:none"> AAA </td> <td class="xl178" style="border-top:none;border-left:none"> CCC </td> </tr> </tbody></table>
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Solved
VBA Function to Paste Table into Outlook Email Resulting in HTML language in Email
Replies
8
Views
623
smozgur
smozgur
E
  • Question Question
VBA code clean up
Replies
9
Views
582
mumps
mumps
T
  • Question Question
Copy row values from one worksheet in one workbook to multiple workbooks based on file name
Replies
0
Views
321
thechad
T
C
  • Solved
Excel 2016 32bit VBA Pulling info from Website to Sheet
Replies
2
Views
2K
CrashOD
C
G
  • Question Question
Complex problem - how many widgets should I sell?
Replies
9
Views
642
Dan_W
D

Forum statistics

Threads
1,224,587
Messages
6,179,738
Members
452,940
Latest member
Lawrenceiow

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top