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 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101
| Sub lancer()
'
' lancer Macro
'
'
Range("D2").Select
Selection.Copy
Sheets("tressage prod").Select
ActiveSheet.Range("$C$6:$I$12").AutoFilter Field:=4, Criteria1:="=1223", _
Operator:=xlAnd
Range("C7:I28").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Consultation opé").Select
Range("C7").Select
ActiveSheet.Paste
Sheets("tressage prod").Select
Range("J7:L28").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Consultation opé").Select
ActiveWindow.ScrollColumn = 2
ActiveWindow.ScrollColumn = 3
Range("P7").Select
ActiveSheet.Paste
ActiveWindow.ScrollColumn = 2
ActiveWindow.ScrollColumn = 1
Range("D2").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("tps d'arrêt tressage").Select
ActiveSheet.ListObjects("Tableau3").Range.AutoFilter Field:=4, Criteria1:= _
"=1223", Operator:=xlAnd
Sheets("Consultation opé").Select
Range("C7").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("tps d'arrêt tressage").Select
ActiveSheet.ListObjects("Tableau3").Range.AutoFilter Field:=1, Criteria1:= _
"=4/06/2013", Operator:=xlAnd
Range("J41:J42").Select
Range("J42").Activate
Sheets("Consultation opé").Select
Range("D7").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("tps d'arrêt tressage").Select
ActiveSheet.ListObjects("Tableau3").Range.AutoFilter Field:=2, Criteria1:= _
"=1223", Operator:=xlAnd
Sheets("Consultation opé").Select
Range("E7").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("tps d'arrêt tressage").Select
ActiveSheet.ListObjects("Tableau3").Range.AutoFilter Field:=3, Criteria1:= _
"=am", Operator:=xlAnd
Range("G5").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Consultation opé").Select
Range("K7").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("tps d'arrêt tressage").Select
Range("G5").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Consultation opé").Select
Range("K7").Select
ActiveSheet.Paste
Sheets("tps d'arrêt tressage").Select
Range("I5").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Consultation opé").Select
Range("L7").Select
ActiveSheet.Paste
Sheets("tps d'arrêt tressage").Select
Range("K5").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Consultation opé").Select
Range("M7").Select
ActiveSheet.Paste
Sheets("tps d'arrêt tressage").Select
Range("M5").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Consultation opé").Select
Range("N7").Select
ActiveSheet.Paste
Sheets("tps d'arrêt tressage").Select
ActiveSheet.ListObjects("Tableau3").Range.AutoFilter Field:=3
ActiveSheet.ListObjects("Tableau3").Range.AutoFilter Field:=4
ActiveSheet.ListObjects("Tableau3").Range.AutoFilter Field:=2
ActiveSheet.ListObjects("Tableau3").Range.AutoFilter Field:=1
Sheets("tressage prod").Select
ActiveSheet.Range("$C$6:$I$12").AutoFilter Field:=4
Sheets("Consultation opé").Select
End Sub |
Partager