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 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56
| Sub Filtre()
'
' Filtre Macro
'
'
Range("A1:D10").Select
Selection.Copy
Sheets("Criteres").Select
ActiveSheet.Paste
Range("E1").Select
Application.CutCopyMode = False
Selection.AutoFilter
ActiveSheet.Range("$A$1:$D$10").AutoFilter Field:=3, Criteria1:="France"
Range("A1:D9").Select
Selection.Copy
Workbooks.Add
ActiveSheet.Paste
Range("E1").Select
Application.CutCopyMode = False
ChDir "C:\Users\Joseph\Documents\Doc_Jo\VBA\Macro_Excel"
ActiveWorkbook.SaveAs Filename:= _
"C:\Repertoire\France_filtre.xlsx", _
FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False
ActiveWindow.Close
ActiveSheet.ShowAllData
Range("E1").Select
ActiveSheet.Range("$A$1:$D$10").AutoFilter Field:=3, Criteria1:="Espagne"
Range("A1:D6").Select
Selection.Copy
Workbooks.Add
ActiveSheet.Paste
Range("E1").Select
Application.CutCopyMode = False
ActiveWorkbook.SaveAs Filename:= _
"C:\Users\Repertoire\Espagne_filtre.xlsx", _
FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False
ActiveWindow.Close
ActiveSheet.ShowAllData
ActiveSheet.Range("$A$1:$D$10").AutoFilter Field:=3, Criteria1:="Danemark"
Range("A1:D10").Select
Selection.Copy
Workbooks.Add
ActiveSheet.Paste
Range("E1").Select
Application.CutCopyMode = False
ActiveWorkbook.SaveAs Filename:= _
"C:\Repertoire\Danemark_filtre.xlsx", _
FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False
ActiveWindow.Close
Columns("A:I").Select
Selection.Delete Shift:=xlToLeft
Range("A1").Select
Sheets("Base").Select
Range("E1").Select
End Sub |
Partager