Dim i As Integer
Dim j As Integer
Dim h As Integer
h = 4
For j = (4) To (70)
Windows("Classeur 1.xls"). _
Activate
Sheets("Feuille 1").Select
Range("D4").Select
ActiveCell.FormulaR1C1 = j
Range("E15:E175").Select
Selection.Copy
Windows("Classeur 2.xls"). _
Activate
Sheets("Feuille 1").Select
Cells(3, h).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Windows("Classeur 1.xls"). _
Activate
Sheets("Feuille 1").Select
Range("D9
12").Select
Selection.Copy
Windows("Classeur 2.xls"). _
Activate
Sheets("Feuille 2").Select
Cells(j, 4).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
If j = 4 Then
j = 5
End If
If j = 7 Then
j = 9
End If
If j = 17 Then
j = 18
End If
If j = 19 Then
j = 59
End If
h = h + 1
Next j