Sub macro1()
'Feuil1 et Feuil2 sont les CodeNames des feuilles
Dim crit As Range
Feuil2.Cells.Clear 'RAZ
With Feuil1.Range("A1", Feuil1.UsedRange)
Set crit = .Cells(1, .Columns.Count + 1).Resize(2)
crit(2).FormulaR1C1 = "=SUMPRODUCT(N(TRIM(RC1:RC[-1])<>""""))"
.AdvancedFilter xlFilterInPlace, crit
.SpecialCells(xlCellTypeVisible).EntireRow.Copy Feuil2.[A1]
.AdvancedFilter xlFilterInPlace, ""
crit = ""
Feuil2.Activate 'facultatif
End With
End Sub