Sub MAJ()
Dim Ligne As Long, C As Range, Plage As Range, L As Variant
With Workbooks("Base de données.xlsx").Sheets(1)
Set Plage = .Range("C2", .Cells(.Rows.Count, 3).End(xlUp))
End With
With ThisWorkbook.Sheets(1)
Ligne = .[A:A].Find("*", , , , xlByRows, xlPrevious).Row
For Each C In Plage
Debug.Print C.Value
L = Application.Match(C, .[B:B], 0)
If Not IsNumeric(L) Then
Ligne = Ligne + 1
.Cells(Ligne, 1) = C.Offset(, -1).Value
.Cells(Ligne, 2) = C.Value
.Cells(Ligne, 3) = C.Offset(, 1)
.Cells(Ligne, 4) = C.Offset(, 4)
.Cells(Ligne, 5) = C.Offset(, 5)
.Cells(Ligne, 6) = C.Offset(, 8)
.Cells(Ligne, 7) = C.Offset(, 11)
.Cells(Ligne, 8) = C.Offset(, 13)
End If
Next C
End With
End Sub