Macro to create seperate tabs from data

K

Kim B

Board Regular
Joined
Jun 16, 2008
Messages
233
Office Version
  1. 365
Hello all. I know this has been done before but I can't find it. I need to create seperate tabs within the same worksheet for each change in the customer name, bringing all data for that customer to its new tab. My columns continue on to R but I deleted them for simplicity

thank you

Sheet1

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Tahoma,Arial; FONT-SIZE: 10pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 111px"><COL style="WIDTH: 127px"><COL style="WIDTH: 127px"><COL style="WIDTH: 201px"><COL style="WIDTH: 218px"><COL style="WIDTH: 71px"><COL style="WIDTH: 87px"><COL style="WIDTH: 71px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD> </TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>H</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e3e3e3; FONT-FAMILY: Andale WT; FONT-WEIGHT: bold">Customer Type</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e3e3e3; FONT-FAMILY: Andale WT; FONT-WEIGHT: bold">Company Number</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e3e3e3; FONT-FAMILY: Andale WT; FONT-WEIGHT: bold">Customer Number</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e3e3e3; FONT-FAMILY: Andale WT; FONT-WEIGHT: bold">Customer Name</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e3e3e3; FONT-FAMILY: Andale WT; FONT-WEIGHT: bold">Original Document Number</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e3e3e3; FONT-FAMILY: Andale WT; FONT-WEIGHT: bold">Days Past</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e3e3e3; FONT-FAMILY: Andale WT; FONT-WEIGHT: bold">Invoice Date</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e3e3e3; FONT-FAMILY: Andale WT; FONT-WEIGHT: bold">Total AR</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">I101</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">142111</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">AB</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11180365</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">0</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">Jun 27, 2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">489,846</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">I102</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">55555511</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">AB</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11180331</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">0</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">Jun 9, 2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">8,018</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">I102</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">55555511</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">AB</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11180491</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">0</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">Aug 17, 2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">6,551</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">I111</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">19002111</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">GMBH (CO)</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11034715</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">157</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">Dec 28, 2010</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">812</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">I111</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">19002111</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">GMBH (CO)</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11034879</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">156</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">Dec 29, 2010</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">208</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">I111</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">19002111</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">GMBH (CO)</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11116794</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">0</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">Jun 6, 2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">4,905</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">I111</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">19002111</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">GMBH (CO)</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11118140</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">0</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">Jun 21, 2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">2,927</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">I111</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">35131211</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">HEXAGON METROLOGY (LEITZ) GMBH</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11108245</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">162</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">Mar 23, 2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">-1,020</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">I111</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">35131211</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">(LEITZ) </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11180372</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">0</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">Jun 29, 2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">59,657</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">I113</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">87777011</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">S.P.A.</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11113217</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">31</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">May 3, 2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">381</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">I113</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">87777011</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">S.P.A.</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11116332</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">2</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">Jun 1, 2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">4,886</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">I113</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">87777011</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">S.P.A.</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11116333</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">2</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">Jun 1, 2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">12,686</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">I113</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">87777011</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">S.P.A.</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11116514</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">0</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">Jun 3, 2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">1,131</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">I113</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">87777011</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">S.P.A.</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11116922</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">0</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">Jun 8, 2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">1,609</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">16</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">I113</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">87777011</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">S.P.A.</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11117520</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">0</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">Jun 15, 2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">21,862</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">17</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">I113</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">87777011</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">S.P.A.</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11117521</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">0</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">Jun 15, 2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">3,052</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">18</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">I113</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">87777011</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">S.P.A.</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11117590</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">0</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">Jun 15, 2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11,052</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">19</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">I113</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">87777011</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">S.P.A.</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11117753</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">0</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">Jun 16, 2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">2,166</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">20</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">I113</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">87777011</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">S.P.A.</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11117943</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">0</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">Jun 17, 2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">3,201</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">21</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">I117</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">24135611</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">LIMITED</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11116319</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">2</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">Jun 1, 2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">906</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">22</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">I117</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">24135611</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">LIMITED</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11116328</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">2</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">Jun 1, 2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">1,358</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">23</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">I117</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">24135611</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">LIMITED</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11116335</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">2</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">Jun 1, 2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">757</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">24</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">I117</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">24135611</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">LIMITED</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11116430</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">1</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">Jun 2, 2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">13,997</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">25</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">I117</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">24135611</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">LIMITED</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11116431</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">1</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">Jun 2, 2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">13,997</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">26</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">I118</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">43469611</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">FRANCE</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11101725</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">133</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">Jan 21, 2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">326</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">27</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">I118</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">43469611</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">FRANCE</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11117948</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">0</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">Jun 17, 2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">935</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">28</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">I118</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">43469611</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">FRANCE</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11118053</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">0</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">Jun 20, 2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">2,596</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">29</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">I118</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">43469611</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">FRANCE</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11118113</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">0</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">Jun 20, 2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">3,183</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">30</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">I119</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">45091611</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">S.A. SPAIN</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11119712</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">66</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">Jun 27, 2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">-99</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">31</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">I119</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">45091611</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">S.A. SPAIN</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11122398</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">0</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">Jul 29, 2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">4,100</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">32</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">I119</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">45091611</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">S.A. SPAIN</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11123080</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">0</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">Aug 4, 2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">406</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">33</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">I120</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">44209511</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">S.A (SWITZ)</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11113778</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">24</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">May 10, 2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">55</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">34</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">I120</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">44209511</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">S.A (SWITZ)</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11117319</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">0</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">Jun 13, 2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">133</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">35</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">I120</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">44209511</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">S.A (SWITZ)</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11120405</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">0</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">Jul 11, 2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">439</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">36</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">I120</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">44209511</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">S.A (SWITZ)</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11121018</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">0</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">Jul 18, 2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">3,822</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">37</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">I120</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">44209511</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">S.A (SWITZ)</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11190772</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">49</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">Apr 15, 2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">-736</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">38</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">I120</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">44209511</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">S.A (SWITZ)</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11190870</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">128</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">Apr 26, 2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">-495</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">39</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">I121</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">51117011</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">MAKINA TICARET</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11006569</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">443</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">Mar 17, 2010</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">29,986</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">40</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">I121</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">51117011</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">MAKINA TICARET</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11018158</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">323</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">Jul 15, 2010</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">320</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">41</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">I121</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">51117011</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">MAKINA TICARET</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11031331</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">192</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">Nov 23, 2010</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">4,149</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">42</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">I122</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">75096011</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">NORDIC AB</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11116300</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">3</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">May 31, 2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">981</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">43</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">I122</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">75096011</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">NORDIC AB</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11119954</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">0</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">Jul 1, 2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">922</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">44</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">I122</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">75096011</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">NORDIC AB</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11121945</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">0</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">Jul 26, 2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">901</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">45</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">I122</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">75096011</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">NORDIC AB</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11123069</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">0</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">Aug 4, 2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">1,058</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">46</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">I123</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">19009611</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">SP. ZO.O.</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11032547</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">178</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">Dec 7, 2010</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">56</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">47</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">I123</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">19009611</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">SP. ZO.O.</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11032782</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">176</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">Dec 9, 2010</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">183</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">48</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">I123</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">19009611</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">SP. ZO.O.</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11117364</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">0</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">Jun 13, 2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">3,792</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">49</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">I124</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">50406811</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">S.R.O.</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11116576</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">0</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">Jun 3, 2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">350</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">50</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">I124</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">50406811</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">S.R.O.</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11118660</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">0</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">Jun 23, 2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">1,931</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">51</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">I124</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">50406811</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">S.R.O.</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11119494</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">0</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">Jun 29, 2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">49</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">52</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">I124</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">50406811</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">S.R.O.</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11122358</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">0</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">Jul 28, 2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">271</TD></TR></TBODY></TABLE>

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4

Sheet2

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Tahoma,Arial; FONT-SIZE: 10pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 103px"><COL style="WIDTH: 123px"><COL style="WIDTH: 123px"><COL style="WIDTH: 109px"><COL style="WIDTH: 184px"><COL style="WIDTH: 68px"><COL style="WIDTH: 86px"><COL style="WIDTH: 64px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD> </TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>H</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e3e3e3; FONT-FAMILY: Andale WT; FONT-WEIGHT: bold">Customer Type</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e3e3e3; FONT-FAMILY: Andale WT; FONT-WEIGHT: bold">Company Number</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e3e3e3; FONT-FAMILY: Andale WT; FONT-WEIGHT: bold">Customer Number</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e3e3e3; FONT-FAMILY: Andale WT; FONT-WEIGHT: bold">Customer Name</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e3e3e3; FONT-FAMILY: Andale WT; FONT-WEIGHT: bold">Original Document Number</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e3e3e3; FONT-FAMILY: Andale WT; FONT-WEIGHT: bold">Days Past</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e3e3e3; FONT-FAMILY: Andale WT; FONT-WEIGHT: bold">Invoice Date</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e3e3e3; FONT-FAMILY: Andale WT; FONT-WEIGHT: bold">Total AR</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">I101</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">142111</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">AB</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11180365</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">0</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">Jun 27, 2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">489,846</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">I102</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">55555511</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">AB</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11180331</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">0</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">Jun 9, 2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">8,018</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">I102</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">55555511</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">AB</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11180491</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">0</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">Aug 17, 2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">6,551</TD></TR></TBODY></TABLE>

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4

Sheet3

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Tahoma,Arial; FONT-SIZE: 10pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 103px"><COL style="WIDTH: 123px"><COL style="WIDTH: 123px"><COL style="WIDTH: 109px"><COL style="WIDTH: 73px"><COL style="WIDTH: 68px"><COL style="WIDTH: 86px"><COL style="WIDTH: 61px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD> </TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>H</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e3e3e3; FONT-FAMILY: Andale WT; FONT-WEIGHT: bold">Customer Type</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e3e3e3; FONT-FAMILY: Andale WT; FONT-WEIGHT: bold">Company Number</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e3e3e3; FONT-FAMILY: Andale WT; FONT-WEIGHT: bold">Customer Number</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e3e3e3; FONT-FAMILY: Andale WT; FONT-WEIGHT: bold">Customer Name</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e3e3e3; FONT-FAMILY: Andale WT; FONT-WEIGHT: bold">Original Document Number</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e3e3e3; FONT-FAMILY: Andale WT; FONT-WEIGHT: bold">Days Past</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e3e3e3; FONT-FAMILY: Andale WT; FONT-WEIGHT: bold">Invoice Date</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e3e3e3; FONT-FAMILY: Andale WT; FONT-WEIGHT: bold">Total AR</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">I111</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">19002111</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">GMBH (CO)</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11034715</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">157</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">Dec 28, 2010</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">812</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">I111</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">19002111</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">GMBH (CO)</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11034879</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">156</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">Dec 29, 2010</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">208</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">I111</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">19002111</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">GMBH (CO)</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11116794</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">0</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">Jun 6, 2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">4,905</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">I111</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">19002111</TD><TD style="FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">GMBH (CO)</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">11118140</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">0</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">Jun 21, 2011</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Andale WT; FONT-SIZE: 8pt">2,927</TD></TR></TBODY></TABLE>

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4
 

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand
Sort by date Sort by votes
This works for me
Code: 
Option Explicit

Sub ParseItems()
'Jerry Beaucaire  (11/11/2009)
'Based on selected column, data is filtered to individual sheets
'Creates sheets and sorts sheets alphabetically in workbook
'6/10/2010 - added check to abort if only one value in vCol
Dim LR As Long, Itm As Long, MyCount As Long, vCol As Long
Dim ws As Worksheet, MyArr As Variant, vTitles As String, Oops As Boolean

Application.ScreenUpdating = False

'Column to evaluate from, column A = 1, B = 2, etc.
   vCol = 4
 
'Sheet with data in it
   Set ws = Sheets("Sheet1")

'Range where titles are across top of data, as string, data MUST
'have titles in this row, edit to suit your titles locale
    vTitles = "A1:H1"
   
'Spot bottom row of data
   LR = ws.Cells(ws.Rows.count, vCol).End(xlUp).Row

'Get a temporary list of unique values from column A
    ws.Columns(vCol).SpecialCells(xlConstants).AdvancedFilter Action:=xlFilterCopy, _
        CopyToRange:=ws.Range("EE1"), Unique:=True

'Sort the temporary list
    ws.Columns("EE:EE").Sort key1:=ws.Range("EE2"), _
        Order1:=xlAscending, Header:=xlYes, ordercustom:=1, _
        MatchCase:=False, Orientation:=xlTopToBottom, _
        DataOption1:=xlSortNormal

'Check for more than one value in list
    If ws.Range("EE" & Rows.count).End(xlUp).Row > 2 Then

'Put list into an array for looping
'(values cannot be the result of formulas, must be constants)
        MyArr = Application.WorksheetFunction.Transpose(ws.Range("EE2:EE" _
            & Rows.count).SpecialCells(xlCellTypeConstants))

'clear temporary worksheet list
        ws.Range("EE:EE").Clear

    Else
        ws.Range("EE:EE").Clear
        Oops = True
        GoTo ErrorExit
    End If
    
'Turn on the autofilter, one column only is all that is needed
    ws.Range(vTitles).AutoFilter

'Loop through list one value at a time
    For Itm = 1 To UBound(MyArr)
        ws.Range(vTitles).AutoFilter Field:=vCol, Criteria1:=MyArr(Itm)
    
        If Not Evaluate("=ISREF('" & MyArr(Itm) & "'!A1)") Then    'create sheet if needed
            Worksheets.Add(After:=Worksheets(Worksheets.count)).Name = MyArr(Itm)
        Else                                                      'clear sheet if it exists
            Sheets(MyArr(Itm)).Move After:=Sheets(Sheets.count)
            Sheets(MyArr(Itm)).Cells.Clear
        End If

    'customize this section as needed for copy/paste targets
        ws.Range("A" & ws.Range(vTitles).Resize(1, 1).Row & ":A" & LR) _
            .EntireRow.Copy Sheets(MyArr(Itm) & "").Range("A1")

        
        ws.Range(vTitles).AutoFilter Field:=vCol
        MyCount = MyCount + Sheets(MyArr(Itm)) _
            .Range("A" & Rows.count).End(xlUp).Row - 1
        Sheets(MyArr(Itm)).Columns.AutoFit
    Next Itm
    
'Cleanup
    ws.AutoFilterMode = False
    MsgBox "Rows with data: " & (LR - 1) & vbLf & "Rows copied to other sheets: " _
                & MyCount & vbLf & "Hope they match!!"

ErrorExit:
    If Oops Then MsgBox "Only one value found, aborting parse process..."
    Application.ScreenUpdating = True
End Sub
 
Upvote 0
Thanks for the support. I am using this macro, but my names are longer than the macros allows. Is there a variation to accept longer names?

Option Explicit
Sub DistributeRows()
Dim wsAll As Worksheet
Dim wsCrit As Worksheet
Dim wsNew As Worksheet
Dim LastRow As Long
Dim LastRowCrit As Long
Dim I As Long

Set wsAll = Worksheets("All") ' change All to the name of the worksheet the existing data is on

LastRow = wsAll.Range("A" & Rows.Count).End(xlUp).Row

Set wsCrit = Worksheets.Add

' column G has the criteria eg project ref
wsAll.Range("G1:G" & LastRow).AdvancedFilter Action:=xlFilterCopy, CopyToRange:=wsCrit.Range("A1"), Unique:=True

LastRowCrit = wsCrit.Range("A" & Rows.Count).End(xlUp).Row
For I = 2 To LastRowCrit

Set wsNew = Worksheets.Add
wsNew.Name = wsCrit.Range("A2")
wsAll.Rows("1:" & LastRow).AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=wsCrit.Range("A1:A2"), _
CopyToRange:=wsNew.Range("A1"), Unique:=False
wsCrit.Rows(2).Delete

Next I

Application.DisplayAlerts = False
wsCrit.Delete
Application.DisplayAlerts = True

End Sub
 
Upvote 0
Kim B,


Thanks for the support. I am using this macro, but my names are longer than the macros allows. Is there a variation to accept longer names?
Click to expand...


Does your actual raw data look like the screenshot you posted at the beginning, Reply #1?


If not, can we have screenshots of your actual raw data, and what the new worksheets will look like?
 
Upvote 0
Kim B,


Sample original raw data worksheet:


Excel Workbook
ABCDEFGH
1Customer TypeCompany NumberCustomer NumberCustomer NameOriginal Document NumberDays PastInvoice DateTotal AR
2I10111142111AB11180365027-Jun-11489,846
3I1021155555511AB1118033109-Jun-118,018
4I1021155555511AB11180491017-Aug-116,551
5I1111119002111GMBH (CO)1103471515728-Dec-10812
6I1111119002111GMBH (CO)1103487915629-Dec-10208
7I1111119002111GMBH (CO)1111679406-Jun-114,905
8I1111119002111GMBH (CO)11118140021-Jun-112,927
9I1111135131211HEXAGON METROLOGY (LEITZ) GMBH1110824516223-Mar-11-1,020
10I1111135131211(LEITZ)11180372029-Jun-1159,657
11I1131187777011S.P.A.11113217313-May-11381
12I1131187777011S.P.A.1111633221-Jun-114,886
13I1131187777011S.P.A.1111633321-Jun-1112,686
14I1131187777011S.P.A.1111651403-Jun-111,131
15I1131187777011S.P.A.1111692208-Jun-111,609
16I1131187777011S.P.A.11117520015-Jun-1121,862
17I1131187777011S.P.A.11117521015-Jun-113,052
18I1131187777011S.P.A.11117590015-Jun-1111,052
19I1131187777011S.P.A.11117753016-Jun-112,166
20I1131187777011S.P.A.11117943017-Jun-113,201
21I1171124135611LIMITED1111631921-Jun-11906
22I1171124135611LIMITED1111632821-Jun-111,358
23I1171124135611LIMITED1111633521-Jun-11757
24I1171124135611LIMITED1111643012-Jun-1113,997
25I1171124135611LIMITED1111643112-Jun-1113,997
26I1181143469611FRANCE1110172513321-Jan-11326
27I1181143469611FRANCE11117948017-Jun-11935
28I1181143469611FRANCE11118053020-Jun-112,596
29I1181143469611FRANCE11118113020-Jun-113,183
30I1191145091611S.A. SPAIN111197126627-Jun-11-99
31I1191145091611S.A. SPAIN11122398029-Jul-114,100
32I1191145091611S.A. SPAIN1112308004-Aug-11406
33I1201144209511S.A (SWITZ)111137782410-May-1155
34I1201144209511S.A (SWITZ)11117319013-Jun-11133
35I1201144209511S.A (SWITZ)11120405011-Jul-11439
36I1201144209511S.A (SWITZ)11121018018-Jul-113,822
37I1201144209511S.A (SWITZ)111907724915-Apr-11-736
38I1201144209511S.A (SWITZ)1119087012826-Apr-11-495
39I1211151117011MAKINA TICARET1100656944317-Mar-1029,986
40I1211151117011MAKINA TICARET1101815832315-Jul-10320
41I1211151117011MAKINA TICARET1103133119223-Nov-104,149
42I1221175096011NORDIC AB11116300331-May-11981
43I1221175096011NORDIC AB1111995401-Jul-11922
44I1221175096011NORDIC AB11121945026-Jul-11901
45I1221175096011NORDIC AB1112306904-Aug-111,058
46I1231119009611SP. ZO.O.110325471787-Dec-1056
47I1231119009611SP. ZO.O.110327821769-Dec-10183
48I1231119009611SP. ZO.O.11117364013-Jun-113,792
49I1241150406811S.R.O.1111657603-Jun-11350
50I1241150406811S.R.O.11118660023-Jun-111,931
51I1241150406811S.R.O.11119494029-Jun-1149
52I1241150406811S.R.O.11122358028-Jul-11271
53
Sheet1





Excel Jeanie is not allowing me to display out to column R for all the raw data:


Excel Workbook
ABCDEFGHIJKLMNOPQR
1Customer TypeCompany NumberCustomer NumberCustomer NameOriginal Document NumberDays PastInvoice DateTotal ARIJKLMNOPQR
Sheet1





After the macro (for just a few of the new worksheets:


Excel Workbook
ABCDEFGHIJKLMNOPQR
1Customer TypeCompany NumberCustomer NumberCustomer NameOriginal Document NumberDays PastInvoice DateTotal ARIJKLMNOPQR
2I1241150406811S.R.O.1111657603-Jun-11350
3I1241150406811S.R.O.11118660023-Jun-111,931
4I1241150406811S.R.O.11119494029-Jun-1149
5I1241150406811S.R.O.11122358028-Jul-11271
6
S.R.O.





Excel Workbook
ABCDEFGHIJKLMNOPQR
1Customer TypeCompany NumberCustomer NumberCustomer NameOriginal Document NumberDays PastInvoice DateTotal ARIJKLMNOPQR
2I1111119002111GMBH (CO)1103471515728-Dec-10812
3I1111119002111GMBH (CO)1103487915629-Dec-10208
4I1111119002111GMBH (CO)1111679406-Jun-114,905
5I1111119002111GMBH (CO)11118140021-Jun-112,927
6
GMBH (CO)





Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).

1. Copy the below code, by highlighting the code and pressing the keys CTRL + C
2. Open your workbook
3. Press the keys ALT + F11 to open the Visual Basic Editor
4. Press the keys ALT + I to activate the Insert menu
5. Press M to insert a Standard Module
6. Where the cursor is flashing, paste the code by pressing the keys CTRL + V
7. Press the keys ALT + Q to exit the Editor, and return to Excel
8. To run the macro from Excel, open the workbook, and press ALT + F8 to display the Run Macro Dialog. Double Click the macro's name to Run it.


Code: 
Option Explicit
Sub DistributeRows()
' hiker95, 08/14/2011
' http://www.mrexcel.com/forum/showthread.php?t=578589
' Original code by Norie, DistributeRows
' http://www.mrexcel.com/forum/showthread.php?t=315083
Dim wsAll As Worksheet, wsCrit As Worksheet, wsNew As Worksheet
Dim LastRow As Long, LastRowCrit As Long, I As Long
Application.ScreenUpdating = False
Set wsAll = Worksheets("Sheet1")
LastRow = wsAll.Range("D" & Rows.Count).End(xlUp).Row
Set wsCrit = Worksheets.Add
wsAll.Range("D1:D" & LastRow).AdvancedFilter Action:=xlFilterCopy, CopyToRange:=wsCrit.Range("A1"), Unique:=True
LastRowCrit = wsCrit.Range("A" & Rows.Count).End(xlUp).Row
For I = 2 To LastRowCrit
  Set wsNew = Worksheets.Add
  wsNew.Name = wsCrit.Range("A2")
  wsAll.Rows("1:" & LastRow).AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=wsCrit.Range("A1:A2"), CopyToRange:=wsNew.Range("A1"), Unique:=False
  wsCrit.Rows(2).Delete
Next I
Application.DisplayAlerts = False
wsCrit.Delete
Application.DisplayAlerts = True
Application.ScreenUpdating = True
End Sub


Then run the DistributeRows macro.
 
Upvote 0
I originally shortened the names manually before i created the snapshot to make it easier to read. But now i am getting a microsoft visual basic error 400. It is creating some of the tabs but not all. There are 38 companies that are not populating to tabs. Those 38 companies are showing up in a sheet labeled sheet 2 and they vary in length. Some are only 6 letters long so it's not a name length issue like I originally thought. The other strange thing is my first tab is labeled sheet 12 and is blank
 
Upvote 0
Kim B,


To attach screenshots, see below in my Signature block: Post a screen shot with one of these:


If you are not able to give us screenshots, see below in my Signature block: You can upload your workbook to Box Net, mark the workbook for sharing, and provide us with a link to your workbook.
 
Upvote 0
I use Excel Jeanie all the time, how do you get the worksheet tabs to show in the screen shot
 
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
616
smozgur
smozgur
E
  • Question Question
VBA code clean up
Replies
9
Views
573
mumps
mumps
E
  • Question Question
Adding a custom message.
Replies
1
Views
659
Micron
M
G
  • Question Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
1K
gvsumich
G
A
  • Question Question
VBA - Automatically Break the Line in HTML format.
Replies
7
Views
2K
Attrazion
A

Forum statistics

Threads
1,224,514
Messages
6,179,225
Members
452,896
Latest member
IGT

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