ActiveSheet.Range("$A$1:$D$27").AutoFilter Field:=3, Criteria1:="<>"
Columns("A:A").Select
Selection.Copy
Sheets("Bon de commande").Select
Sheets("Bon de commande").Paste
Sheets("Commande").Select
Columns("C:C").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Bon de commande").Select
Range("H3").Select
Sheets("Commande").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Bon de commande").Select
ActiveSheet.Paste