Sub Macro1()
'
' Macro1 Macro
'
' Touche de raccourci du clavier: Ctrl+Shift+C
'
Range("K4:M9").Select
Range("K9").Activate
Selection.Copy
Sheets("Feuil2").Select
Range("K10").Select
ActiveSheet.Paste
End Sub
Sub Macro2()
'
' Macro2 Macro
'
' Touche de raccourci du clavier: Ctrl+m
'
Sheets("Feuil2").Select
Selection.Copy
Sheets("Feuil3").Select
Range("AF2").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Feuil4").Select
ActiveWindow.ScrollRow = 64934
ActiveWindow.ScrollRow = 64724
ActiveWindow.ScrollRow = 64514
ActiveWindow.ScrollRow = 64304
ActiveWindow.ScrollRow = 63253
ActiveWindow.ScrollRow = 60731
ActiveWindow.ScrollRow = 59471
ActiveWindow.ScrollRow = 56529
ActiveWindow.ScrollRow = 54217
ActiveWindow.ScrollRow = 49804
ActiveWindow.ScrollRow = 41189
ActiveWindow.ScrollRow = 39928
ActiveWindow.ScrollRow = 36566
ActiveWindow.ScrollRow = 28791
ActiveWindow.ScrollRow = 23747
ActiveWindow.ScrollRow = 19545
ActiveWindow.ScrollRow = 15552
ActiveWindow.ScrollRow = 2
Range("AE21").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
ActiveWindow.SmallScroll Down:=18
Sheets("Feuil5").Select
ActiveWindow.SmallScroll Down:=20
Range("AE32").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Feuil3").Select
Columns("B:AF").Select
Application.CutCopyMode = False
Selection.Copy
Range("AF1").Select
Application.CutCopyMode = False
ActiveCell.FormulaR1C1 = "31"
Columns("B:AF").Select
Range("AF1").Activate
Selection.Copy
Range("AK1").Select
ActiveSheet.Paste
Sheets("Feuil2").Select
ActiveSheet.Shapes.Range(Array("Text Box 1")).Select
Application.CutCopyMode = False
Sheets("Feuil3").Select
Range("AK2").Select
ActiveCell.FormulaR1C1 = "=IF(RC[-35]=""X"",RC[1]+1,0)"
Range("AK2").Select
ActiveCell.FormulaR1C1 = "=IF(RC[-35]=""X"",RC[-1]+1,0)"
Range("AK2").Select
Selection.AutoFill Destination:=Range("AK2:BO2"), Type:=xlFillDefault
Range("AK2:BO2").Select
Selection.AutoFill Destination:=Range("AK2:BO100001"), Type:=xlFillDefault
Range("AK2:BO100001").Select
Selection.Copy
Sheets("Feuil4").Select
Columns("A:AE").Select
Range("AE1").Activate
Application.CutCopyMode = False
Selection.Copy
Range("AJ1").Select
ActiveSheet.Paste
Sheets("Feuil5").Select
Columns("A:AE").Select
Range("AE1").Activate
Application.CutCopyMode = False
Selection.Copy
Range("AJ1").Select
ActiveSheet.Paste
ActiveWindow.SmallScroll Down:=-20
Sheets("Feuil4").Select
ActiveWindow.SmallScroll Down:=-18
Sheets("Feuil3").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Feuil3").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Feuil2").Select
Application.CutCopyMode = False
Sheets("Feuil4").Select
Range("AJ2").Select
ActiveCell.FormulaR1C1 = "=IF(RC[-35]=""X"",RC[-1]+1,0)"
Range("AJ2").Select
Selection.AutoFill Destination:=Range("AJ2:BN2"), Type:=xlFillDefault
Range("AJ2:BN2").Select
Selection.AutoFill Destination:=Range("AJ2:BN100047"), Type:=xlFillDefault
Range("AJ2:BN100047").Select
Selection.Copy
ActiveWindow.ScrollRow = 99818
ActiveWindow.ScrollRow = 94354
ActiveWindow.ScrollRow = 82376
ActiveWindow.ScrollRow = 67457
ActiveWindow.ScrollRow = 54218
ActiveWindow.ScrollRow = 48754
ActiveWindow.ScrollRow = 44551
ActiveWindow.ScrollRow = 43711
ActiveWindow.ScrollRow = 43501
ActiveWindow.ScrollRow = 41189
ActiveWindow.ScrollRow = 26059
ActiveWindow.ScrollRow = 7567
ActiveWindow.ScrollRow = 2
Sheets("Feuil5").Select
Range("AJ2").Select
ActiveSheet.Paste
Sheets("Feuil4").Select
Application.CutCopyMode = False
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Feuil5").Select
Application.CutCopyMode = False
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Feuil2").Select
ActiveSheet.Shapes.Range(Array("Zone de texte 1")).Select
End Sub