Lorsque j'enregistre en macro voici ce que je fais, En d'autre terme comment le généraliser et l'automamtiser?
Sub pe()
for i=1 to 42000
Selection.AutoFilter Field:=1, Criteria1:="NEMCSIKANDREA"
Selection.AutoFilter Field:=3, Criteria1:="mars-04"
Range("E11885:E20489").Select
Range("E20489").Activate
ActiveCell.FormulaR1C1 = "=IF(SUBTOTAL(9,R[-8604]C:R[-1]C)" , then
Range("L11885").Select
ActiveCell.FormulaR1C1 = "ok"
Selection.FillDown
Selection.AutoFilter Field:=3, Criteria1:="mai-04"
Range("E20489").Select
ActiveCell.FormulaR1C1 = "=SUBTOTAL(9,R[-8604]C:R[-1]C)"
Range("L12977").Select
ActiveCell.FormulaR1C1 = "ok"
Selection.FillDown
Selection.AutoFilter Field:=3, Criteria1:="avr.-04"
Range("L12265").Select
ActiveCell.FormulaR1C1 = "ok"
Selection.FillDown
Selection.AutoFilter Field:=3, Criteria1:="févr.-04"
Range("L11484").Select
ActiveCell.FormulaR1C1 = "ok"
Selection.FillDown
Selection.AutoFilter Field:=3
Range("L11326").Select
ActiveCell.FormulaR1C1 = "ok"
Selection.FillDown
Selection.AutoFilter Field:=1, Criteria1:="NENDAKABIKAANGADAA"
Range("E10678").Select
Range(Selection, Selection.End(xlDown)).Select
ActiveWindow.SmallScroll Down:=6
Range("E20489").Select
Selection.ClearContents
Range("E10678").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.AutoFilter Field:=3, Criteria1:="mars-04"
ActiveWindow.SmallScroll Down:=-12
Range("L11283").Select
ActiveCell.FormulaR1C1 = "vide"
Selection.FillDown
Selection.AutoFilter Field:=3, Criteria1:="mai-04"
Range("L12138").Select
ActiveCell.FormulaR1C1 = "ok"
Selection.FillDown
Selection.AutoFilter Field:=11
Selection.AutoFilter Field:=3, Criteria1:="mars-04"
Range("L11283").Select
ActiveCell.FormulaR1C1 = "not"
Selection.FillDown
Selection.AutoFilter Field:=3, Criteria1:="mai-04"
Selection.AutoFilter Field:=3, Criteria1:="août-04"
Selection.AutoFilter Field:=11, Criteria1:="="
Selection.AutoFilter Field:=3, Criteria1:="juin-04"
Range("L12559").Select
ActiveCell.FormulaR1C1 = "ok"
Selection.FillDown
Selection.AutoFilter Field:=3, Criteria1:="août-04"
Range("L13322").Select
ActiveCell.FormulaR1C1 = "ok"
Selection.FillDown
Selection.AutoFilter Field:=3, Criteria1:="avr.-04"
Range("L11784").Select
ActiveCell.FormulaR1C1 = "not ok"
Selection.FillDown
Selection.AutoFilter Field:=3, Criteria1:="févr.-04"
Range("L10898").Select
ActiveCell.FormulaR1C1 = "ok"
Selection.FillDown
Selection.AutoFilter Field:=3, Criteria1:="janv.-04"
Range("L10678").Select
ActiveCell.FormulaR1C1 = "ok"
Selection.FillDown
Selection.AutoFilter Field:=3
Range("L12922").Select
ActiveCell.FormulaR1C1 = "ok"
Selection.FillDown
next i
End Sub