Sub Copie_Ligne()
Dim Lig As Long
Dim Col As String
Dim NbrLig As Long
Dim NumLig As Long
Sheets("BaseDeDonnéesGlobal").Activate
Col = "o"
NumLig = 2
With Sheets("BaseDeDonnéesGlobal")
NbrLig = .Cells(65536, Col).End(xlUp).Row
For Lig = 3 To NbrLig
If .Cells(Lig, Col).Value = "X" Then
.Cells(Lig, Col).EntireRow.Copy
NumLig = NumLig + 1
Sheets("resultats").Cells(NumLig, 1).Insert Shift:=xlDown
End If
Next
End With
End Sub