Bonjour amayas, le forum,
Un essai....
Sub copieAM()
Dim dl1 As Long, dl2 As Long
Application.ScreenUpdating = False
Application.DisplayAlerts = False
With Sheets("AM")
dl2 = .Range("A" & Rows.Count).End(xlUp).Row + 1
End With
With Sheets("Feuil1")
dl1 = .Range("A" & Rows.Count).End(xlUp).Row
.Range("A4:Z" & dl1).AutoFilter field:=15, Criteria1:="AM"
.Range("A5:Z" & dl1).SpecialCells(xlVisible).Copy Sheets("AM").Range("A" & dl2)
.Range("A5:Z" & dl1).SpecialCells(xlVisible).Delete
If .FilterMode = True Then .ShowAllData
End With
Application.ScreenUpdating = True
Application.DisplayAlerts = True
End Sub
CTRL + e pour exécuter la macro...
Cordialement,