'Boucle globale bilan
Do While B <> N
Select Case X
Case 1 To 5
'Définition du nom du mois
M = "JANVIER"
'Recopie les mois en haut du suivi ro îlot machines
Range("BR30:BV30").Copy
Range("C3").PasteSpecial _
Paste:=xlValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
'Insertion des valeurs depuis le tableau de droite vers le tableau SUIVI RO îlot machines
Range("M3").Select
ActiveCell.Offset(A, 1).Select
Range(ActiveCell, ActiveCell.Offset(1, 4)).Copy
Range("D3").Select
ActiveCell.Offset(A, 0).PasteSpecial _
Paste:=xlValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
'Si 4 semaines dans le mois, suppression de la cinquème semaine
Case 6 To 9
M = "FEVRIER"
Range("BR31:BV31").Copy
Range("C3").PasteSpecial _
Paste:=xlValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Range("M3").Select
ActiveCell.Offset(A, 6).Select
Range(ActiveCell, ActiveCell.Offset(1, 4)).Copy
Range("D3").Select
ActiveCell.Offset(A, 0).PasteSpecial _
Paste:=xlValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Range("H3").Select
ActiveCell.ClearContents
ActiveCell.Offset(A, 0).Select
Range(ActiveCell, ActiveCell.Offset(1, 0)).ClearContents
Case 10 To 13
M = "MARS"
Range("BR32:BV32").Copy
Range("C3").PasteSpecial _
Paste:=xlValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Range("M3").Select
ActiveCell.Offset(A, 10).Select
Range(ActiveCell, ActiveCell.Offset(1, 4)).Copy
Range("D3").Select
ActiveCell.Offset(A, 0).PasteSpecial _
Paste:=xlValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Range("H3").Select
ActiveCell.ClearContents
ActiveCell.Offset(A, 0).Select
Range(ActiveCell, ActiveCell.Offset(1, 0)).ClearContents
Case 14 To 17
M = "AVRIL"
Range("BR33:BV33").Copy
Range("C3").PasteSpecial _
Paste:=xlValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Range("M3").Select
ActiveCell.Offset(A, 14).Select
Range(ActiveCell, ActiveCell.Offset(1, 4)).Copy
Range("D3").Select
ActiveCell.Offset(A, 0).PasteSpecial _
Paste:=xlValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Range("H3").Select
ActiveCell.ClearContents
ActiveCell.Offset(A, 0).Select
Range(ActiveCell, ActiveCell.Offset(1, 0)).ClearContents
Case 18 To 22
M = "MAI"
Range("BR34:BV34").Copy
Range("C3").PasteSpecial _
Paste:=xlValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Range("M3").Select
ActiveCell.Offset(A, 18).Select
Range(ActiveCell, ActiveCell.Offset(1, 4)).Copy
Range("D3").Select
ActiveCell.Offset(A, 0).PasteSpecial _
Paste:=xlValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Case 23 To 26
M = "JUIN"
Range("BR35:BV35").Copy
Range("C3").PasteSpecial _
Paste:=xlValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Range("M3").Select
ActiveCell.Offset(A, 23).Select
Range(ActiveCell, ActiveCell.Offset(1, 4)).Copy
Range("D3").Select
ActiveCell.Offset(A, 0).PasteSpecial _
Paste:=xlValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Range("H3").Select
ActiveCell.ClearContents
ActiveCell.Offset(A, 0).Select
Range(ActiveCell, ActiveCell.Offset(1, 0)).ClearContents
Case 27 To 31
M = "JUILLET"
Range("BR36:BV36").Copy
Range("C3").PasteSpecial _
Paste:=xlValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Range("M3").Select
ActiveCell.Offset(A, 27).Select
Range(ActiveCell, ActiveCell.Offset(1, 4)).Copy
Range("D3").Select
ActiveCell.Offset(A, 0).PasteSpecial _
Paste:=xlValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Range("H3").Select
ActiveCell.ClearContents
ActiveCell.Offset(A, 0).Select
Range(ActiveCell, ActiveCell.Offset(1, 0)).ClearContents
Case 32 To 35
M = "AOUT"
Range("BR37:BV37").Copy
Range("C3").PasteSpecial _
Paste:=xlValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Range("M3").Select
ActiveCell.Offset(A, 32).Select
Range(ActiveCell, ActiveCell.Offset(1, 4)).Copy
Range("D3").Select
ActiveCell.Offset(A, 0).PasteSpecial _
Paste:=xlValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Case 36 To 39
M = "SEPTEMBRE"
Range("BR38:BV38").Copy
Range("C3").PasteSpecial _
Paste:=xlValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Range("M3").Select
ActiveCell.Offset(A, 36).Select
Range(ActiveCell, ActiveCell.Offset(1, 4)).Copy
Range("D3").Select
ActiveCell.Offset(A, 0).PasteSpecial _
Paste:=xlValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Range("H3").Select
ActiveCell.ClearContents
ActiveCell.Offset(A, 0).Select
Range(ActiveCell, ActiveCell.Offset(1, 0)).ClearContents
Case 40 To 44
M = "OCTOBRE"
Range("BR39:BV39").Copy
Range("C3").PasteSpecial _
Paste:=xlValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Range("M3").Select
ActiveCell.Offset(A, 40).Select
Range(ActiveCell, ActiveCell.Offset(1, 4)).Copy
Range("D3").Select
ActiveCell.Offset(A, 0).PasteSpecial _
Paste:=xlValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Case 45 To 48
M = "NOVEMBRE"
Range("BR40:BV34").Copy
Range("C3").PasteSpecial _
Paste:=xlValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Range("M3").Select
ActiveCell.Offset(A, 45).Select
Range(ActiveCell, ActiveCell.Offset(1, 4)).Copy
Range("D3").Select
ActiveCell.Offset(A, 0).PasteSpecial _
Paste:=xlValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Range("H3").Select
ActiveCell.ClearContents
ActiveCell.Offset(A, 0).Select
Range(ActiveCell, ActiveCell.Offset(1, 0)).ClearContents
Case 49 To 52
M = "DECEMBRE"
Range("BR41:BV41").Copy
Range("C3").PasteSpecial _
Paste:=xlValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Range("M3").Select
ActiveCell.Offset(A, 49).Select
Range(ActiveCell, ActiveCell.Offset(1, 4)).Copy
Range("D3").Select
ActiveCell.Offset(A, 0).PasteSpecial _
Paste:=xlValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Range("H3").Select
ActiveCell.ClearContents
ActiveCell.Offset(A, 0).Select
Range(ActiveCell, ActiveCell.Offset(1, 0)).ClearContents
End Select
'Incrément coordonées
A = A + 5
'Incrément compteur
N = N + 1
Loop