1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| With Sheets("1 à 25")
For f = 10 To 59
If .Range("F" & f).Value <> 0 Then
Sheets("resume").Cells(Rows.Count, 1).End(xlUp)(2).Value = IIf(f Mod 2 = 0, .Range("A" & f).Value, .Range("A" & f - 1).Value)
Sheets("resume").Cells(Rows.Count, 3).End(xlUp)(2).Value = IIf(f Mod 2 = 0, .Range("D" & f).Value, .Range("D" & f).Value)
ElseIf .Range("I" & f).Value <> 0 Then
Sheets("resume").Cells(Rows.Count, 1).End(xlUp)(2).Value = IIf(f Mod 2 = 0, .Range("A" & f).Value, .Range("A" & f - 1).Value)
Sheets("resume").Cells(Rows.Count, 5).End(xlUp)(2).Value = IIf(f Mod 2 = 0, .Range("G" & f).Value, .Range("G" & f).Value)
ElseIf .Range("L" & f).Value <> 0 Then
Sheets("resume").Cells(Rows.Count, 1).End(xlUp)(2).Value = IIf(f Mod 2 = 0, .Range("A" & f).Value, .Range("A" & f - 1).Value)
Sheets("resume").Cells(Rows.Count, 5).End(xlUp)(2).Value = IIf(f Mod 2 = 0, .Range("J" & f).Value, .Range("J" & f).Value)
ElseIf .Range("O" & f).Value <> 0 Then
Sheets("resume").Cells(Rows.Count, 1).End(xlUp)(2).Value = IIf(f Mod 2 = 0, .Range("A" & f).Value, .Range("A" & f - 1).Value)
Sheets("resume").Cells(Rows.Count, 5).End(xlUp)(2).Value = IIf(f Mod 2 = 0, .Range("M" & f).Value, .Range("M" & f).Value)
ElseIf .Range("R" & f).Value <> 0 Then
Sheets("resume").Cells(Rows.Count, 1).End(xlUp)(2).Value = IIf(f Mod 2 = 0, .Range("A" & f).Value, .Range("A" & f - 1).Value)
Sheets("resume").Cells(Rows.Count, 5).End(xlUp)(2).Value = IIf(f Mod 2 = 0, .Range("P" & f).Value, .Range("P" & f).Value)
End If
Next f
End With |
Partager