VBA insert row and add data

[ziad alsayed]

dear all
with the below data need to do the following: at each change in invoice number, to insert a new row ,on the added row need to : add the invoice number,the date,the salesman, the customer, Concatenate the description, and add total


<TABLE style="WIDTH: 957pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=1274><COLGROUP><COL style="WIDTH: 83pt; mso-width-source: userset; mso-width-alt: 4022" width=110><COL style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2852" width=78><COL style="WIDTH: 144pt; mso-width-source: userset; mso-width-alt: 7021" width=192><COL style="WIDTH: 197pt; mso-width-source: userset; mso-width-alt: 9581" width=262><COL style="WIDTH: 257pt; mso-width-source: userset; mso-width-alt: 12544" width=343><COL style="WIDTH: 34pt; mso-width-source: userset; mso-width-alt: 1645" width=45><COL style="WIDTH: 69pt; mso-width-source: userset; mso-width-alt: 3364" width=92><COL style="WIDTH: 114pt; mso-width-source: userset; mso-width-alt: 5558" width=152><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 83pt; HEIGHT: 15pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 height=20 width=110>Invoice Numb</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 59pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 width=78>Date</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 144pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 width=192>Salemman</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 197pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 width=262>customer</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 257pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 width=343>Description</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 34pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 width=45>Qty</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 69pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 width=92>Net Ex.VAT</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 114pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 width=152>Net Ex. VAT /USD </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: silver 0.5pt dotted; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 height=20 align=right>103521</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver 0.5pt dotted; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> 01/09/2010</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver 0.5pt dotted; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> INNOCENT OGWOGWO (Phc)</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver 0.5pt dotted; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64>UFUOMA OTOMEWO</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver 0.5pt dotted; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> JGL12.5 (JET) LPW3 with SP</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver 0.5pt dotted; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>1</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver 0.5pt dotted; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>952380.43</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver 0.5pt dotted; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>6349.2</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 height=20 align=right>103521</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> 01/09/2010</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> INNOCENT OGWOGWO (Phc)</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64>UFUOMA OTOMEWO</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> Commissioning</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>1</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>7143</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>47.62</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 height=20 align=right>103580</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> 02/09/2010</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> SPENCER GREEN (Phc)</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64>PACS ASSOCIATES</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> JGP45 (JET) 1103A-33TG1 - LSA43.2</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>1</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>1485713.76</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>9904.75</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 height=20 align=right>103580</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> 02/09/2010</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> SPENCER GREEN (Phc)</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64>PACS ASSOCIATES</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> Commissioning</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>1</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>7143</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>47.62</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 height=20 align=right>103581</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> 02/09/2010</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> EMEKA ELENEWOKE (Phc)</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64>HELMANS PETROLEUM</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> JGL12.5 (JET) LPW3</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>1</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>890475.81</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>5936.51</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 height=20 align=right>103592</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> 06/09/2010</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> JOHNNIE AZIBAOLA (Phc)</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64>CHIEF GABRIEL O. AKPATA</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> JGL12.5 (JET) LPW3</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>1</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>821904.76</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>5479.36</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 height=20 align=right>103593</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> 06/09/2010</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> SPENCER GREEN (Phc)</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64>UMUCHUKWU MICRO FINANCE BANK</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> JGP45 (JET) (1103A-33TG1 - LSA43.2) with SP</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>1</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>1857143.09</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>12380.96</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 height=20 align=right>103594</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> 06/09/2010</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> DORIS KALIO (Phc)</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64>MR A.H BOBMANUEL</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> P44E3 FGWilson (CBU) 1103A-33TG with SA</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>1</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>3296666.19</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>21977.77</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 height=20 align=right>103594</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> 06/09/2010</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> DORIS KALIO (Phc)</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64>MR A.H BOBMANUEL</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> Misc. (Genset)</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>1</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>23810</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>158.73</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 height=20 align=right>103595</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> 06/09/2010</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> SOLOMON IYALLA (Phc)</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64>MABISEL TRADING</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> P33E1 FGWilson (CBU) 1103A-33G1 with SA</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>2</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>4380952.38</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>29206.35</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 height=20 align=right>103598</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> 06/09/2010</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> EMEKA ELENEWOKE (Phc)</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64>IMO STATE MDGS</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> P33E1 FGWilson (CBU) 1103A-33G1 with SA</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>2</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>4380952.38</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>29206.35</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 height=20 align=right>103658</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> 13/09/2010</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> JOHNNIE AZIBAOLA (Phc)</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64>Shell Petroleum Dev. Co.</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> JGP45 (JET) (1103A-33TG1 - LSA43.2) with SP</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>2</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>4300710.66</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>28671.4</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 height=20 align=right>103659</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> 13/09/2010</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> INNOCENT OGWOGWO (Phc)</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64>Messrs TOTAL E & P NIG. LTD</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> P27P1 FGW(CKD) 1103A-33G1 with SP</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>1</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>2085500</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>13903.33</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 height=20 align=right>103660</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> 13/09/2010</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> INNOCENT OGWOGWO (Phc)</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64>Elf Petroleum Nig. Staff Co-oper</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> P33E1 FGWilson (CBU) 1103A-33G1 with SA</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>1</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>2449999.71</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>16333.33</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 height=20 align=right>103661</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> 13/09/2010</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> SPENCER GREEN (Phc)</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64>POZAG NIG LIMITED</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> P18P2 FGW(CKD) 404C-22G1 - LL1014L</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>1</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>1233332.95</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>8222.22</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 height=20 align=right>103662</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> 13/09/2010</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> EMEKA ELENEWOKE (Phc)</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64>NWUTCHE NNAMDI WELI</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> JGP30E (JET) (1103A-33G - LL1014Q) with SP</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>1</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>1838094.86</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>12253.96</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 height=20 align=right>103662</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> 13/09/2010</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> EMEKA ELENEWOKE (Phc)</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64>NWUTCHE NNAMDI WELI</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> Commissioning</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>1</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>4762</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>31.75</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 height=20 align=right>103663</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> 13/09/2010</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> JOHNNIE AZIBAOLA (Phc)</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64>DIAMOND BANK PLC / MRS VICTORIA</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> JGP20 (JET) (404C-22G - LSA42.2S5) with SP</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>1</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>1417142.48</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>9447.61</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 height=20 align=right>103664</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> 13/09/2010</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> SPENCER GREEN (Phc)</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64>OLIVE HOTELS & SUITES</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> P200H2 FGW(CKD) 1306C-E87TAG4 - LL5014F</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>1</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>5368570.81</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>35790.47</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 height=20 align=right>103664</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> 13/09/2010</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> SPENCER GREEN (Phc)</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64>OLIVE HOTELS & SUITES</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> JGP80 (JET) (1104A-44TG2 - LL2014J) with SP</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>1</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>2333333</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>15555.55</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 height=20 align=right>103664</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> 13/09/2010</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> SPENCER GREEN (Phc)</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64>OLIVE HOTELS & SUITES</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> P200-250 Sound Proof (CKD)</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>1</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>809524</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>5396.83</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 height=20 align=right>103664</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> 13/09/2010</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> SPENCER GREEN (Phc)</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64>OLIVE HOTELS & SUITES</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> Commissioning</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>1</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>19048</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>126.99</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 height=20 align=right>103666</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> 13/09/2010</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> DORIS KALIO (Phc)</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64>MEIN NIGERIA LIMITED</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64> P18P2 FGW(CKD) 404C-22G1 - LL1014L</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>1</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>1266666.67</TD><TD style="BORDER-BOTTOM: silver 0.5pt dotted; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: silver; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 align=right>8444.45</TD></TR></TBODY></TABLE>

appreciate any assistance

 

[Peter_SSs]

The 'add total' is not entirely clear since there isn't a column with that label, but I think this should give a reasonable starting point. Test in a copy of your workbook.

I've assumed the data table starts in cell A1.

<font face=Courier New><br><br><SPAN style="color:#00007F">Sub</SPAN> SubtotalPlus()<br>    <SPAN style="color:#00007F">Dim</SPAN> aArea <SPAN style="color:#00007F">As</SPAN> Range<br>    <br>    Application.ScreenUpdating = <SPAN style="color:#00007F">False</SPAN><br>    <SPAN style="color:#00007F">With</SPAN> Range("A1").CurrentRegion<br>        .Subtotal GroupBy:=1, Function:=xlSum, TotalList:=Array(7, 8), _<br>            Replace:=True, PageBreaks:=False, SummaryBelowData:=<SPAN style="color:#00007F">True</SPAN><br>    <SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">With</SPAN><br>    <SPAN style="color:#00007F">For</SPAN> <SPAN style="color:#00007F">Each</SPAN> aArea <SPAN style="color:#00007F">In</SPAN> Range("B2", Range("B" & Rows.Count).End(xlUp)) _<br>                    .SpecialCells(xlCellTypeConstants).Areas<br>        <SPAN style="color:#00007F">With</SPAN> aArea<br>            .Offset(.Rows.Count).Resize(1, 4).Value = _<br>                .Resize(1, 4).Value<br>            <SPAN style="color:#00007F">If</SPAN> .Rows.Count > 1 <SPAN style="color:#00007F">Then</SPAN><br>                .Offset(.Rows.Count, 3).Resize(1).Value = _<br>                    Join(Application.Transpose(.Offset(, 3).Value), ", ")<br>            <SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">If</SPAN><br>        <SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">With</SPAN><br>    <SPAN style="color:#00007F">Next</SPAN> aArea<br>    Application.ScreenUpdating = <SPAN style="color:#00007F">True</SPAN><br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN><br></FONT>

 

[ziad alsayed]

thanks peter , this is exactly what i needed.