1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| Private Sub Worksheet_Activate() ' onglet vendu
Dim der As Long
With Sheets("Inventaire")
Cells.ClearContents
.Rows.Hidden = False
Range("A1:H1").Value = .Range("A1:H1").Value
.Range("M1").Value = "ventes"
.Range("M2").FormulaR1C1 = "=NOT(ISBLANK(RC[-9]))"
der = .Cells(Rows.Count, 1).End(xlUp).Row
.Range("A1:H" & der).AdvancedFilter Action:=xlFilterCopy, _
CriteriaRange:=.Range("M1:M2"), CopyToRange:=Range("A1:H1"), Unique:=False
.Range("M1:M2") = ""
For der = der To 2 Step -1
If .Cells(der, "D") <> "" Then .Rows(der).Hidden = True
Next der
End With
End Sub |
Partager