Bonjour,
salut gmb
voici le complément à ta macro
Sub dupliquer(ok As Boolean)
Dim ici As Range, tbl As ListObject
With ActiveSheet.ListObjects(1)
If .ShowAutoFilter Then .AutoFilter.ShowAllData
Set ici = Cells(Rows.Count, 1).End(xlUp).Offset(3, 0)
.Range.AutoFilter Field:=11, Criteria1:="<30"
.Range.Select
Selection.Copy
ici.Select
With ActiveSheet
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Set tbl = .ListObjects.Add(xlSrcRange, ici.CurrentRegion, , xlYes)
tbl.TableStyle = "TableStyleMedium3"
End With
.AutoFilter.ShowAllData
Set ici = Cells(Rows.Count, 1).End(xlUp).Offset(3, 0)
.Range.AutoFilter Field:=11, Criteria1:=">50"
.Range.Select
Selection.Copy
ici.Select
With ActiveSheet
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Set tbl = .ListObjects.Add(xlSrcRange, ici.CurrentRegion, , xlYes)
tbl.TableStyle = "TableStyleMedium7"
End With
.AutoFilter.ShowAllData
End With
End Sub