1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
| Sheets("Updated Trades Month").Select
ActiveSheet.ShowAllData
Selection.AutoFilter Field:=6, Criteria1:="=*init*", Operator:=xlAnd
Range("A1").Select
Range(Selection, Selection.End(xlDown)).Select
Range(Selection, Selection.End(xlToRight)).Select
Selection.Copy
Sheets("All Updated Trades Month").Select
Range("A1").Select
ActiveSheet.Paste
Selection.AutoFilter Field:=32, Criteria1:="<>", Operator:=xlAnd
Sheets("Updated Trades Month").Select
Range("BA2").Select
Selection.Copy
Sheets("All Updated Trades Month").Select
Range("AG2:AG65536").SpecialCells(xlVisible).Select
ActiveSheet.Paste
ActiveSheet.ShowAllData
'filtre suivant
Sheets("Updated Trades Month").Select
ActiveSheet.ShowAllData
Selection.AutoFilter Field:=7, Criteria1:="=*init*", Operator:=xlAnd
Range("A2:AZ65536").SpecialCells(xlVisible).Copy
Sheets("All Updated Trades Month").Select
Range("A65536").End(xlUp).Offset(1, 0).Cells.Select
ActiveSheet.Paste
Selection.AutoFilter Field:=32, Criteria1:="<>", Operator:=xlAnd
Selection.AutoFilter Field:=33, Criteria1:="", Operator:=xlAnd
Sheets("Updated Trades Month").Select
Range("BA3").Select
Selection.Copy
Sheets("All Updated Trades Month").Select
Range("AG2:AG65536").SpecialCells(xlVisible).Select
ActiveSheet.Paste
ActiveSheet.ShowAllData |
Partager