title: How to optimize my VBA code to work with an 11,000-data database
body: <p>My code goes through my database (list of all the consumables that have left our warehouse in the last 5 years) and adds a consumable on a second sheet each time it encounters a new consumable which has not already been compiled in the second sheet.</p>
  <p>It copies the number of the new consumable as well as 4 other columns describing it in the second sheet. Then, for each data compiled in the second sheet, it goes through the database of the first sheet and checks the sectors of activity in which this consumable has been used. The code therefore makes an X in the cyanidation column for each consumable that has been used in this sector and the same for the flotation column.</p>
  <pre class="lang-vb prettyprint-override"><code>Sub CopierColler()
      
      Application.ScreenUpdating = False    
      Application.EnableEvents = False    
      Application.Calculation = xlCalculationManual
      
      Set Ws1 = ThisWorkbook.Worksheets(&quot;Feuil1&quot;)    
      Set Ws2 = ThisWorkbook.Worksheets(&quot;Feuil2&quot;)
      
      k = 1
      
      While Ws1.Range(&quot;G&quot; &amp; k).Value &lt;&gt; &quot;&quot;    
          k = k + 1    
      Wend
      
      For i = 1 To k    
          h = 1    
          While Ws2.Range(&quot;A&quot; &amp; h).Value &lt;&gt; &quot;&quot;
              h = h + 1
          Wend
          j = 1
          While j &lt; h
              If Ws1.Range(&quot;G&quot; &amp; i).Value &lt;&gt; Ws2.Range(&quot;A&quot; &amp; j).Value Then
              j = j + 1
              Else: j = h + 2
              End If
          Wend
          If j = h Then
          Ws1.Range(&quot;G1:K1&quot;).Offset(i - 1, 0).Copy Ws2.Range(&quot;A1:E1&quot;).Offset(h - 1, 0)
          End If
      Next
      
      k = 1
      
      While Ws2.Range(&quot;A&quot; &amp; k).Value &lt;&gt; &quot;&quot;    
          k = k + 1    
      Wend
      
      For i = 1 To k    
          h = 1    
          While Ws1.Range(&quot;G&quot; &amp; h).Value &lt;&gt; &quot;&quot;
              h = h + 1
          Wend
          j = 1
          While j &lt; h
              If Ws1.Range(&quot;G&quot; &amp; j).Value = Ws2.Range(&quot;A&quot; &amp; i).Value And Ws1.Range(&quot;G&quot; &amp; j).Offset(0, -2).Value = &quot;Flottation&quot; _
              And Ws2.Range(&quot;A&quot; &amp; i).Offset(0, 5).Value = &quot;&quot; Then
              Ws2.Range(&quot;A&quot; &amp; i).Offset(0, 5).Value = &quot;X&quot;
              End If
              If Ws1.Range(&quot;G&quot; &amp; j).Value = Ws2.Range(&quot;A&quot; &amp; i).Value And Ws1.Range(&quot;G&quot; &amp; j).Offset(0, -2).Value = &quot;Cyanuration&quot; _
              And Ws2.Range(&quot;A&quot; &amp; i).Offset(0, 6).Value = &quot;&quot; Then
              Ws2.Range(&quot;A&quot; &amp; i).Offset(0, 6).Value = &quot;X&quot;
              End If
              j = j + 1
          Wend
      Next
      
      Application.ScreenUpdating = True    
      Application.EnableEvents = True    
      Application.Calculation = xlCalculationAutomatic
      
  End Sub
  </code></pre>
  <p>Explanation of code:</p>
  <p>I found the first and last lines on the internet when I was trying to lighten my code.</p>
  <p>Then I start by doing a « while » loop to find the line number (k) corresponding tothe last row of my data sheet (Ws1).</p>
  <p>Then I did a « for » loop that will go through each of the rows of my data sheet (Ws1) until the last (k) . In my « For » loop I did a « While » loop to find the line number (h) corresponding to the last row of my second sheet (Ws2). Then I made another « While » loop which continues as long as my counter j is not = the number of rows (h) of my sheet 2 (Ws2), so for each of the data of my sheet Ws1, I compare them with each data from my Ws2 sheet and if I find that the data from the Ws1 sheet is already in the Ws2 sheet then I exit the « While » loop (h+2) and I go to the next data (i) from my Ws1 sheet (for loop) . However, if the Ws1 data is not in the Ws2 sheet then j=h and I copy the data and its descriptive columns into my sheet 2 (Ws2).</p>
  <p>Then I use the same principle and take each of the data from my Ws2 and search through all the data from the Ws1. With an “If” I find each of the same data and I look in their “sector” column in the Ws1 and if it is written flotation and if an “X” is not yet noted in the flotation column of the Ws2 I add a « X » in the column. I do the same for the Cyanuration sector. (A consumable can be used only in flotation or in cyanidation but also for both.)</p>
  <p>Here is my database reduced to 60 data:</p>
  <p><a href="https://i.stack.imgur.com/Fv2VG.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Fv2VG.png" alt="enter image description here" /></a></p>
  <p>Here is an example of the result of the code on a database of 60 data:</p>
  <p><a href="https://i.stack.imgur.com/SvJhe.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/SvJhe.png" alt="enter image description here" /></a></p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: center;">DATE</th>
  <th style="text-align: center;">Mois</th>
  <th style="text-align: center;">N° Centre de Coûts</th>
  <th style="text-align: center;">Sous-Activité</th>
  <th style="text-align: center;">Secteur</th>
  <th style="text-align: center;">Description De Site</th>
  <th style="text-align: center;">Article</th>
  <th style="text-align: center;">Désignation</th>
  <th style="text-align: center;">Unité</th>
  <th style="text-align: center;">Catégorie</th>
  <th style="text-align: center;">Groupe</th>
  <th style="text-align: center;">Description de Compte</th>
  <th style="text-align: center;">Quantité</th>
  <th style="text-align: center;">P.M.P</th>
  <th style="text-align: center;">Montant</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: center;">2022-01-01</td>
  <td style="text-align: center;">1</td>
  <td style="text-align: center;">220-130</td>
  <td style="text-align: center;">Déblayage   - Production ST</td>
  <td style="text-align: center;">Production</td>
  <td style="text-align: center;">SCOOPS   3T N°1</td>
  <td style="text-align: center;">RP007.3120</td>
  <td style="text-align: center;">PNEU   X-MINE D2 TL 12.00 R24</td>
  <td style="text-align: center;">UN</td>
  <td style="text-align: center;">Fournitures   et Consommables</td>
  <td style="text-align: center;">Fournitures   d'Entretien</td>
  <td style="text-align: center;">Pneus   et Réparation de Pneus</td>
  <td style="text-align: center;">2</td>
  <td style="text-align: center;">17   000</td>
  <td style="text-align: center;">34   000</td>
  </tr>
  <tr>
  <td style="text-align: center;">2022-01-01</td>
  <td style="text-align: center;">1</td>
  <td style="text-align: center;">426-280</td>
  <td style="text-align: center;">Gestion du Parc à Résidus</td>
  <td style="text-align: center;"></td>
  <td style="text-align: center;">DIGUE N° 1 DE L'USINE FLOTTATION</td>
  <td style="text-align: center;">WL011.9015</td>
  <td style="text-align: center;">POMPE A ARBRE NUE MARQUE SEPMA TYPE ARS 65-4</td>
  <td style="text-align: center;">UN</td>
  <td style="text-align: center;">Pièces et Équipement</td>
  <td style="text-align: center;">Autres Composants d'Équipement</td>
  <td style="text-align: center;">Pompes</td>
  <td style="text-align: center;">1</td>
  <td style="text-align: center;">21 080</td>
  <td style="text-align: center;">21 080</td>
  </tr>
  <tr>
  <td style="text-align: center;">2022-01-01</td>
  <td style="text-align: center;">1</td>
  <td style="text-align: center;">220-120</td>
  <td style="text-align: center;">Abattage   - Production ST</td>
  <td style="text-align: center;">Production</td>
  <td style="text-align: center;">ABATTAGE</td>
  <td style="text-align: center;">NA001.3250</td>
  <td style="text-align: center;">CARTOUCHE   TOVEX S2 DIA.30/250</td>
  <td style="text-align: center;">KG</td>
  <td style="text-align: center;">Fournitures   et Consommables</td>
  <td style="text-align: center;">Explosifs</td>
  <td style="text-align: center;">Explosif   (Émulsion)</td>
  <td style="text-align: center;">305</td>
  <td style="text-align: center;">31</td>
  <td style="text-align: center;">9   564</td>
  </tr>
  <tr>
  <td style="text-align: center;">2022-06-15</td>
  <td style="text-align: center;">6</td>
  <td style="text-align: center;">422-210</td>
  <td style="text-align: center;"></td>
  <td style="text-align: center;">Flottation</td>
  <td style="text-align: center;">CONCASSAGE    A MACHOIRE PRIMIAIRE FL</td>
  <td style="text-align: center;">AT002.4210</td>
  <td style="text-align: center;">TOLE CREUSABRO 2000X1000X10 QUALITE 8000</td>
  <td style="text-align: center;">UN</td>
  <td style="text-align: center;">Fournitures et Consommables</td>
  <td style="text-align: center;">Fournitures d'Entretien</td>
  <td style="text-align: center;">Plaques et Poutres d'Acier</td>
  <td style="text-align: center;">7</td>
  <td style="text-align: center;">4 320</td>
  <td style="text-align: center;">30 240</td>
  </tr>
  <tr>
  <td style="text-align: center;">2022-02-04</td>
  <td style="text-align: center;">2</td>
  <td style="text-align: center;">422-230</td>
  <td style="text-align: center;">Flottation</td>
  <td style="text-align: center;">Flottation</td>
  <td style="text-align: center;">FLOTTATION</td>
  <td style="text-align: center;">LC002.1122</td>
  <td style="text-align: center;">AMMONIUM   DIBUTYL DITHIOPHOSPHATE</td>
  <td style="text-align: center;">KG</td>
  <td style="text-align: center;">Fournitures   et Consommables</td>
  <td style="text-align: center;">Produits   Chimiques et Réactifs</td>
  <td style="text-align: center;">Ammonium   Dibutyl</td>
  <td style="text-align: center;">1   200</td>
  <td style="text-align: center;">21</td>
  <td style="text-align: center;">25   349</td>
  </tr>
  <tr>
  <td style="text-align: center;">2022-01-01</td>
  <td style="text-align: center;">1</td>
  <td style="text-align: center;">2204</td>
  <td style="text-align: center;">Développment Minier</td>
  <td style="text-align: center;"></td>
  <td style="text-align: center;">CESSIONS SOCIETE TRAGI</td>
  <td style="text-align: center;">NA002.0001</td>
  <td style="text-align: center;">AMORCE RETARD LONGUEUR FIL 2.5m</td>
  <td style="text-align: center;">UN</td>
  <td style="text-align: center;">Fournitures et Consommables</td>
  <td style="text-align: center;">Explosifs</td>
  <td style="text-align: center;">Accessoire de Dynamitage</td>
  <td style="text-align: center;">327</td>
  <td style="text-align: center;">19</td>
  <td style="text-align: center;">6 257</td>
  </tr>
  <tr>
  <td style="text-align: center;">2022-01-01</td>
  <td style="text-align: center;">1</td>
  <td style="text-align: center;">424-245</td>
  <td style="text-align: center;">Cementation   et Fusion</td>
  <td style="text-align: center;"></td>
  <td style="text-align: center;">FONDERIE   DE FUSION</td>
  <td style="text-align: center;">NG001.0001</td>
  <td style="text-align: center;">GASOIL   50/10 PPM</td>
  <td style="text-align: center;">L</td>
  <td style="text-align: center;">Fournitures   et Consommables</td>
  <td style="text-align: center;">Carburant   et Lubrification</td>
  <td style="text-align: center;">Diesel</td>
  <td style="text-align: center;">600</td>
  <td style="text-align: center;">8</td>
  <td style="text-align: center;">4   997</td>
  </tr>
  <tr>
  <td style="text-align: center;">2022-01-01</td>
  <td style="text-align: center;">1</td>
  <td style="text-align: center;">110-101</td>
  <td style="text-align: center;">Exploration - Zgounder</td>
  <td style="text-align: center;"></td>
  <td style="text-align: center;">GROUPE ELECTROGENE 500KVA N°1</td>
  <td style="text-align: center;">NG001.0001</td>
  <td style="text-align: center;">GASOIL 50/10 PPM</td>
  <td style="text-align: center;">L</td>
  <td style="text-align: center;">Fournitures et Consommables</td>
  <td style="text-align: center;">Carburant et Lubrification</td>
  <td style="text-align: center;">Diesel</td>
  <td style="text-align: center;">400</td>
  <td style="text-align: center;">8</td>
  <td style="text-align: center;">3 332</td>
  </tr>
  <tr>
  <td style="text-align: center;">2022-01-01</td>
  <td style="text-align: center;">1</td>
  <td style="text-align: center;">1002</td>
  <td style="text-align: center;">Bassin   de rétention d'eau</td>
  <td style="text-align: center;"></td>
  <td style="text-align: center;">CAMION   DE LOCATION 8*4 (1827-A-74)</td>
  <td style="text-align: center;">NG001.0001</td>
  <td style="text-align: center;">GASOIL   50/10 PPM</td>
  <td style="text-align: center;">L</td>
  <td style="text-align: center;">Fournitures   et Consommables</td>
  <td style="text-align: center;">Carburant   et Lubrification</td>
  <td style="text-align: center;">Diesel</td>
  <td style="text-align: center;">204</td>
  <td style="text-align: center;">8</td>
  <td style="text-align: center;">1   699</td>
  </tr>
  <tr>
  <td style="text-align: center;">2022-01-01</td>
  <td style="text-align: center;">1</td>
  <td style="text-align: center;">220-110</td>
  <td style="text-align: center;">Forage - Production ST</td>
  <td style="text-align: center;">Production</td>
  <td style="text-align: center;">COMPRESSEUR MOBILE N°2 (FOND) REF : 102</td>
  <td style="text-align: center;">NG001.0001</td>
  <td style="text-align: center;">GASOIL 50/10 PPM</td>
  <td style="text-align: center;">L</td>
  <td style="text-align: center;">Fournitures et Consommables</td>
  <td style="text-align: center;">Carburant et Lubrification</td>
  <td style="text-align: center;">Diesel</td>
  <td style="text-align: center;">200</td>
  <td style="text-align: center;">8</td>
  <td style="text-align: center;">1 666</td>
  </tr>
  <tr>
  <td style="text-align: center;">2022-01-01</td>
  <td style="text-align: center;">1</td>
  <td style="text-align: center;">1002</td>
  <td style="text-align: center;">Bassin   de rétention d'eau</td>
  <td style="text-align: center;"></td>
  <td style="text-align: center;">POCLIN   DE LOCATION</td>
  <td style="text-align: center;">NG001.0001</td>
  <td style="text-align: center;">GASOIL   50/10 PPM</td>
  <td style="text-align: center;">L</td>
  <td style="text-align: center;">Fournitures   et Consommables</td>
  <td style="text-align: center;">Carburant   et Lubrification</td>
  <td style="text-align: center;">Diesel</td>
  <td style="text-align: center;">200</td>
  <td style="text-align: center;">8</td>
  <td style="text-align: center;">1   666</td>
  </tr>
  <tr>
  <td style="text-align: center;">2022-01-01</td>
  <td style="text-align: center;">1</td>
  <td style="text-align: center;">1002</td>
  <td style="text-align: center;">Bassin de rétention d'eau</td>
  <td style="text-align: center;"></td>
  <td style="text-align: center;">POCLIN DE LOCATION</td>
  <td style="text-align: center;">NG001.0001</td>
  <td style="text-align: center;">GASOIL 50/10 PPM</td>
  <td style="text-align: center;">L</td>
  <td style="text-align: center;">Fournitures et Consommables</td>
  <td style="text-align: center;">Carburant et Lubrification</td>
  <td style="text-align: center;">Diesel</td>
  <td style="text-align: center;">200</td>
  <td style="text-align: center;">8</td>
  <td style="text-align: center;">1 666</td>
  </tr>
  <tr>
  <td style="text-align: center;">2022-01-01</td>
  <td style="text-align: center;">1</td>
  <td style="text-align: center;">1002</td>
  <td style="text-align: center;">Bassin   de rétention d'eau</td>
  <td style="text-align: center;"></td>
  <td style="text-align: center;">POCLIN   DE LOCATION</td>
  <td style="text-align: center;">NG001.0001</td>
  <td style="text-align: center;">GASOIL   50/10 PPM</td>
  <td style="text-align: center;">L</td>
  <td style="text-align: center;">Fournitures   et Consommables</td>
  <td style="text-align: center;">Carburant   et Lubrification</td>
  <td style="text-align: center;">Diesel</td>
  <td style="text-align: center;">200</td>
  <td style="text-align: center;">8</td>
  <td style="text-align: center;">1   666</td>
  </tr>
  <tr>
  <td style="text-align: center;">2022-01-01</td>
  <td style="text-align: center;">1</td>
  <td style="text-align: center;">1002</td>
  <td style="text-align: center;">Bassin de rétention d'eau</td>
  <td style="text-align: center;"></td>
  <td style="text-align: center;">COMPACTEUR LOCATION</td>
  <td style="text-align: center;">NG001.0001</td>
  <td style="text-align: center;">GASOIL 50/10 PPM</td>
  <td style="text-align: center;">L</td>
  <td style="text-align: center;">Fournitures et Consommables</td>
  <td style="text-align: center;">Carburant et Lubrification</td>
  <td style="text-align: center;">Diesel</td>
  <td style="text-align: center;">200</td>
  <td style="text-align: center;">8</td>
  <td style="text-align: center;">1 666</td>
  </tr>
  <tr>
  <td style="text-align: center;">2022-06-30</td>
  <td style="text-align: center;">6</td>
  <td style="text-align: center;">422-230</td>
  <td style="text-align: center;"></td>
  <td style="text-align: center;">Flottation</td>
  <td style="text-align: center;">FLOTTATION</td>
  <td style="text-align: center;">LC002.1122</td>
  <td style="text-align: center;">AMMONIUM   DIBUTYL DITHIOPHOSPHATE</td>
  <td style="text-align: center;">KG</td>
  <td style="text-align: center;">Fournitures   et Consommables</td>
  <td style="text-align: center;">Produits   Chimiques et Réactifs</td>
  <td style="text-align: center;">Ammonium   Dibutyl</td>
  <td style="text-align: center;">1   065</td>
  <td style="text-align: center;">21</td>
  <td style="text-align: center;">22   497</td>
  </tr>
  <tr>
  <td style="text-align: center;">2022-01-01</td>
  <td style="text-align: center;">1</td>
  <td style="text-align: center;">422-260</td>
  <td style="text-align: center;">Opérations Concentrateur</td>
  <td style="text-align: center;">Flottation</td>
  <td style="text-align: center;">SUPERVISION USINE FLOTTATION</td>
  <td style="text-align: center;">KT007.3420</td>
  <td style="text-align: center;">COURROIE TRAPEZOIDALE C135  SECTION 22x3420</td>
  <td style="text-align: center;">UN</td>
  <td style="text-align: center;">Pièces et Équipement</td>
  <td style="text-align: center;">Revêtements et pièces d'usure</td>
  <td style="text-align: center;">Courroies</td>
  <td style="text-align: center;">8</td>
  <td style="text-align: center;">185</td>
  <td style="text-align: center;">1 480</td>
  </tr>
  <tr>
  <td style="text-align: center;">2022-01-01</td>
  <td style="text-align: center;">1</td>
  <td style="text-align: center;">426-280</td>
  <td style="text-align: center;">Gestion   du Parc à Résidus</td>
  <td style="text-align: center;"></td>
  <td style="text-align: center;">CHARGEUSE   SUR PNEUS 950H</td>
  <td style="text-align: center;">NG001.0001</td>
  <td style="text-align: center;">GASOIL   50/10 PPM</td>
  <td style="text-align: center;">L</td>
  <td style="text-align: center;">Fournitures   et Consommables</td>
  <td style="text-align: center;">Carburant   et Lubrification</td>
  <td style="text-align: center;">Diesel</td>
  <td style="text-align: center;">171</td>
  <td style="text-align: center;">8</td>
  <td style="text-align: center;">1   424</td>
  </tr>
  <tr>
  <td style="text-align: center;">2022-01-01</td>
  <td style="text-align: center;">1</td>
  <td style="text-align: center;">220-140</td>
  <td style="text-align: center;">Roulage - Production ST</td>
  <td style="text-align: center;">Production</td>
  <td style="text-align: center;">DUMPER N°4</td>
  <td style="text-align: center;">NG001.0001</td>
  <td style="text-align: center;">GASOIL 50/10 PPM</td>
  <td style="text-align: center;">L</td>
  <td style="text-align: center;">Fournitures et Consommables</td>
  <td style="text-align: center;">Carburant et Lubrification</td>
  <td style="text-align: center;">Diesel</td>
  <td style="text-align: center;">167</td>
  <td style="text-align: center;">8</td>
  <td style="text-align: center;">1 391</td>
  </tr>
  <tr>
  <td style="text-align: center;">2022-01-01</td>
  <td style="text-align: center;">1</td>
  <td style="text-align: center;">422-260</td>
  <td style="text-align: center;">Opérations   Concentrateur</td>
  <td style="text-align: center;">Flottation</td>
  <td style="text-align: center;">SUPERVISION   USINE FLOTTATION</td>
  <td style="text-align: center;">KT007.2946</td>
  <td style="text-align: center;">COURROIE   TRAPEZOIDALE C116 SECTION 22x2946</td>
  <td style="text-align: center;">UN</td>
  <td style="text-align: center;">Pièces   et Équipement</td>
  <td style="text-align: center;">Revêtements   et pièces d'usure</td>
  <td style="text-align: center;">Courroies</td>
  <td style="text-align: center;">6</td>
  <td style="text-align: center;">200</td>
  <td style="text-align: center;">1   200</td>
  </tr>
  <tr>
  <td style="text-align: center;">2022-01-01</td>
  <td style="text-align: center;">1</td>
  <td style="text-align: center;">422-230</td>
  <td style="text-align: center;">Flottation</td>
  <td style="text-align: center;">Flottation</td>
  <td style="text-align: center;">FLOTTATION</td>
  <td style="text-align: center;">TV060.6100</td>
  <td style="text-align: center;">VANNEA OPERCULE A BRIDE  DE 4&quot;</td>
  <td style="text-align: center;">UN</td>
  <td style="text-align: center;">Pièces et Équipement</td>
  <td style="text-align: center;">Autres Composants d'Équipement</td>
  <td style="text-align: center;">Tuyaux et Raccords de Tuyauterie</td>
  <td style="text-align: center;">1</td>
  <td style="text-align: center;">1 063</td>
  <td style="text-align: center;">1 063</td>
  </tr>
  <tr>
  <td style="text-align: center;">2022-01-01</td>
  <td style="text-align: center;">1</td>
  <td style="text-align: center;">422-240</td>
  <td style="text-align: center;">Épaississeur   et Filtration</td>
  <td style="text-align: center;">Flottation</td>
  <td style="text-align: center;">FILTRATION   FL</td>
  <td style="text-align: center;">EC001.6706</td>
  <td style="text-align: center;">CONTACTEUR   REF.LC1D8011M5 R/P REF.LC1D80M5 TELEMECANIQUE</td>
  <td style="text-align: center;">UN</td>
  <td style="text-align: center;">Pièces   et Équipement</td>
  <td style="text-align: center;">Pièces   Électriques</td>
  <td style="text-align: center;">Pièces   de Rechange Électrique</td>
  <td style="text-align: center;">1</td>
  <td style="text-align: center;">980</td>
  <td style="text-align: center;">980</td>
  </tr>
  <tr>
  <td style="text-align: center;">2022-01-01</td>
  <td style="text-align: center;">1</td>
  <td style="text-align: center;">422-230</td>
  <td style="text-align: center;">Flottation</td>
  <td style="text-align: center;">Flottation</td>
  <td style="text-align: center;">FLOTTATION</td>
  <td style="text-align: center;">TT801.0004</td>
  <td style="text-align: center;">VANNE OCA PN16 DN 100</td>
  <td style="text-align: center;">UN</td>
  <td style="text-align: center;">Pièces et Équipement</td>
  <td style="text-align: center;">Autres Composants d'Équipement</td>
  <td style="text-align: center;">Tuyaux et Raccords de Tuyauterie</td>
  <td style="text-align: center;">1</td>
  <td style="text-align: center;">940</td>
  <td style="text-align: center;">940</td>
  </tr>
  <tr>
  <td style="text-align: center;">2022-01-01</td>
  <td style="text-align: center;">1</td>
  <td style="text-align: center;">220-130</td>
  <td style="text-align: center;">Déblayage   - Production ST</td>
  <td style="text-align: center;">Production</td>
  <td style="text-align: center;">SCOOPS   3T N°1</td>
  <td style="text-align: center;">RP012.2120</td>
  <td style="text-align: center;">CHAMBRE   A AIR 1200X24</td>
  <td style="text-align: center;">UN</td>
  <td style="text-align: center;">Fournitures   et Consommables</td>
  <td style="text-align: center;">Fournitures   d'Entretien</td>
  <td style="text-align: center;">Pneus   et Réparation de Pneus</td>
  <td style="text-align: center;">2</td>
  <td style="text-align: center;">420</td>
  <td style="text-align: center;">840</td>
  </tr>
  <tr>
  <td style="text-align: center;">2022-01-01</td>
  <td style="text-align: center;">1</td>
  <td style="text-align: center;">220-130</td>
  <td style="text-align: center;">Déblayage - Production ST</td>
  <td style="text-align: center;">Production</td>
  <td style="text-align: center;">SCOOPS 6T N°5</td>
  <td style="text-align: center;">NG001.0001</td>
  <td style="text-align: center;">GASOIL 50/10 PPM</td>
  <td style="text-align: center;">L</td>
  <td style="text-align: center;">Fournitures et Consommables</td>
  <td style="text-align: center;">Carburant et Lubrification</td>
  <td style="text-align: center;">Diesel</td>
  <td style="text-align: center;">100</td>
  <td style="text-align: center;">8</td>
  <td style="text-align: center;">833</td>
  </tr>
  <tr>
  <td style="text-align: center;">2022-01-01</td>
  <td style="text-align: center;">1</td>
  <td style="text-align: center;">220-130</td>
  <td style="text-align: center;">Déblayage   - Production ST</td>
  <td style="text-align: center;">Production</td>
  <td style="text-align: center;">SCOOPS   TORO 10T</td>
  <td style="text-align: center;">NG001.0001</td>
  <td style="text-align: center;">GASOIL   50/10 PPM</td>
  <td style="text-align: center;">L</td>
  <td style="text-align: center;">Fournitures   et Consommables</td>
  <td style="text-align: center;">Carburant   et Lubrification</td>
  <td style="text-align: center;">Diesel</td>
  <td style="text-align: center;">100</td>
  <td style="text-align: center;">8</td>
  <td style="text-align: center;">833</td>
  </tr>
  <tr>
  <td style="text-align: center;">2022-01-01</td>
  <td style="text-align: center;">1</td>
  <td style="text-align: center;">220-130</td>
  <td style="text-align: center;">Déblayage - Production ST</td>
  <td style="text-align: center;">Production</td>
  <td style="text-align: center;">SCOOPS 6T N°5</td>
  <td style="text-align: center;">NH002.0168</td>
  <td style="text-align: center;">HUILE HYDROLIQUE AW 68</td>
  <td style="text-align: center;">L</td>
  <td style="text-align: center;">Fournitures et Consommables</td>
  <td style="text-align: center;">Carburant et Lubrification</td>
  <td style="text-align: center;">Huile a Moteur</td>
  <td style="text-align: center;">35</td>
  <td style="text-align: center;">24</td>
  <td style="text-align: center;">830</td>
  </tr>
  <tr>
  <td style="text-align: center;">2022-01-01</td>
  <td style="text-align: center;">1</td>
  <td style="text-align: center;">220-140</td>
  <td style="text-align: center;">Roulage   - Production ST</td>
  <td style="text-align: center;">Production</td>
  <td style="text-align: center;">DUMPER   N°3</td>
  <td style="text-align: center;">XD002.0008</td>
  <td style="text-align: center;">POCHETTE   DE JOINT POUR CYLINDRE REF.213010021 P/DUMPER-8</td>
  <td style="text-align: center;">UN</td>
  <td style="text-align: center;">Pièces   et Équipement</td>
  <td style="text-align: center;">Revêtements   et pièces d'usure</td>
  <td style="text-align: center;">Pièces   d'Usure</td>
  <td style="text-align: center;">1</td>
  <td style="text-align: center;">782</td>
  <td style="text-align: center;">782</td>
  </tr>
  <tr>
  <td style="text-align: center;">2022-01-01</td>
  <td style="text-align: center;">1</td>
  <td style="text-align: center;">220-140</td>
  <td style="text-align: center;">Roulage - Production ST</td>
  <td style="text-align: center;">Production</td>
  <td style="text-align: center;">DUMPER N°4</td>
  <td style="text-align: center;">NH002.0168</td>
  <td style="text-align: center;">HUILE HYDROLIQUE AW 68</td>
  <td style="text-align: center;">L</td>
  <td style="text-align: center;">Fournitures et Consommables</td>
  <td style="text-align: center;">Carburant et Lubrification</td>
  <td style="text-align: center;">Huile a Moteur</td>
  <td style="text-align: center;">30</td>
  <td style="text-align: center;">24</td>
  <td style="text-align: center;">711</td>
  </tr>
  <tr>
  <td style="text-align: center;">2022-01-01</td>
  <td style="text-align: center;">1</td>
  <td style="text-align: center;">220-130</td>
  <td style="text-align: center;">Déblayage   - Production ST</td>
  <td style="text-align: center;">Production</td>
  <td style="text-align: center;">SCOOPS   3T N°1</td>
  <td style="text-align: center;">XS001.0074</td>
  <td style="text-align: center;">RETENUE   REF.203040334 P/CHARGEUSE TRANSPORTEUSE SCOOP-1.5</td>
  <td style="text-align: center;">UN</td>
  <td style="text-align: center;">Pièces   et Équipement</td>
  <td style="text-align: center;">Revêtements   et pièces d'usure</td>
  <td style="text-align: center;">Pièces   d'Usure</td>
  <td style="text-align: center;">1</td>
  <td style="text-align: center;">711</td>
  <td style="text-align: center;">711</td>
  </tr>
  </tbody>
  </table>
  </div>