Sub Transferer()
Application.ScreenUpdating = False
DLMesJeux = 1 + Sheets("Mes Jeux").Range("C65500").End(xlUp).Row
DLFin = Range("C65500").End(xlUp).Row
For Ligne = 5 To DLFin
If Cells(Ligne, "M") = "J" Then
Sheets("Mes Jeux").Range("C" & DLMesJeux & ":H" & DLMesJeux) = _
Range("C" & Ligne & ":H" & Ligne).Value
DLMesJeux = DLMesJeux + 1
End If
With Sheets("Mes Jeux")
.Range("C4:H4").Copy
.Range("C4:H" & DLMesJeux - 1).PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
End With
Next Ligne
End Sub