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
 
Sort by date Sort by votes
Kim B,

Your screenshots in your initial post #1 are displaying the worksheet names.


When you select a range in a worksheet, and launch Excel Jeanie, in the middle/top of the Excel Jeanie box, section Spreadsheets make sure there is a checkmark in/for Use table names as title.
 
Upvote 0

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.
Kim B,

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.
Click to expand...


Something to think about. Worksheet names can not be longer than 31 characters for Excel 2003 and 2007. And, some company names may have characters that can not be used for a worksheet name.
 
Upvote 0
The macro from post #2, tweaked for you book, seems to do it:

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("Interco")

'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:Z1"
   
'Spot bottom row of data
   LR = ws.Cells(ws.Rows.Count, vCol).End(xlUp).Row

'Get a temporary list of unique values from column vCol
    ws.Columns(vCol).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)
        If Not IsError(MyArr(Itm)) Then
            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
        End If
    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

you do need t fix the data in Interco!D239:D249 so it reads TESA US.
 
Upvote 0
Works perfectly, even totals to master sheet!

I was trying to use the smaller macro becasue I actually could follow it.

thanks again
 
Upvote 0
Any questions, let me know, the commenting makes it look longer than it is, if those comments need more info, I'll add them.
 
Upvote 0
Hi all, I am trying to run this macro and am getting a syntax error on Sub parse items. I am not working on a computer that has excel jenie on it, so unfortuately i cannot send a screen shot of the data. i was hoping it was something dumb that an expert eye could pick out.


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("Interco")
'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:Z1"

'Spot bottom row of data
LR = ws.Cells(ws.Rows.Count, vCol).End(xlUp).Row
'Get a temporary list of unique values from column vCol
ws.Columns(vCol).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)
If Not IsError(MyArr(Itm)) Then
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
End If
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 Subyou do need t fix the data in Interco!D239:D249 so it reads TESA US.
__________________
 
Upvote 0
The last line should just be
Code: 
End Sub
not
Code: 
End Subyou do need t fix the data in Interco!D239:D249 so it reads TESA US.
 
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,517
Messages
6,179,242
Members
452,898
Latest member
Capolavoro009

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