1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
| Sub ingredients()
Dim LastLig As Long
Application.ScreenUpdating = False
With Worksheets("calcul")
.AutoFilterMode = False
LastLig = .Cells(.Rows.Count, "F").End(xlUp).Row
.Range("F1:H" & LastLig).AutoFilter field:=3, Criteria1:=">0"
.Range("G1:H" & LastLig).SpecialCells(xlCellTypeVisible).Copy
Worksheets("liste").Range("A1").PasteSpecial Paste:=xlValues
.Range("F1:F" & LastLig).SpecialCells(xlCellTypeVisible).Copy
Worksheets("liste").Range("C1").PasteSpecial Paste:=xlValues
.Range("D1:D" & LastLig).SpecialCells(xlCellTypeVisible).Copy
Worksheets("liste").Range("D1").PasteSpecial Paste:=xlValues
.Range("C1:C" & LastLig).SpecialCells(xlCellTypeVisible).Copy
Worksheets("liste").Range("E1").PasteSpecial Paste:=xlValues
Application.CutCopyMode = False
.AutoFilterMode = False
End With
End Sub |
Partager