Sub Extraction_commande()
Dim derli As Long, l As Long, y As Long, derCol As Long, tabCom()
Worksheets("COM").Activate
derli = Cells.Find("*", [A1], , , 1, 2).Row
derCol = Cells.Find("*", [A1], , , 2, 2).Column
tbl = Range("A2571", Cells(derli, derCol))
' supprimer les données de 2KE_SDS
Call supp_extraction
For l = 1 To UBound(tbl, 1)
If tbl(l, 1) = "COM" Then
y = y + 1
ReDim Preserve tabCom(1 To 10, 1 To y) 'les colonnes en ligne pour pouvoir ajouter des lignes
tabCom(1, y) = tbl(l, 13)
tabCom(2, y) = tbl(l, 3)
tabCom(3, y) = tbl(l, 12)
tabCom(4, y) = tbl(l, 4)
tabCom(5, y) = tbl(l, 14)
tabCom(6, y) = tbl(l, 1)
tabCom(7, y) = tbl(l, 18)
tabCom(8, y) = tbl(l, 11)
tabCom(9, y) = tbl(l, 15)
tabCom(10, y) = tbl(l, 6)
End If
Next l
tabCom = Application.Transpose(tabCom)
Worksheets("2KE_SDS").Activate
l = 2
For y = 1 To UBound(tabCom, 1)
Range(l, 3) = tabCom(y, 1)
Range(l, 6) = tabCom(y, 2)
Range(l, 7) = tabCom(y, 3)
Range(l, 8) = tabCom(y, 4)
Range(l, 9) = tabCom(y, 5)
Range(l, 10) = tabCom(y, 6)
Range(l, 11) = tabCom(y, 7)
Range(l, 15) = tabCom(y, 8)
Range(l, 20) = tabCom(y, 9)
Range(l, 21) = tabCom(y, 10)
l = l + 1
Next y
End Sub
Sub supp_extraction()
'
' supp_données existantes colonne C, F a K, O et T & U
'
Worksheets("2KE_SDS").Activate
Range("F2:K1500").ClearContents
Range("C2:C1500").ClearContents
Range("O2:O1500").ClearContents
Range("T2: u1500").ClearContents
Range("A2").Select
End Sub