Sub Macro1()
'
Application.ScreenUpdating = False
' Macro1 Macro
'
Dim tablo() As Variant
'
tablo = Sheets("Abonnements 2018").Range("A1").CurrentRegion.Value
With Sheets("Final")
For i = LBound(tablo, 1) + 1 To UBound(tablo, 1)
If UCase(tablo(i, 3)) = "OUI" Then
For j = 13 To 24 'pour chaque mois
Fin = .Range("A" & .Rows.Count).End(xlUp).Row + 1
.Range("A" & Fin) = DateSerial(2018, j - 12, 1) 'Date
.Range("B" & Fin) = WorksheetFunction.Substitute(tablo(i, 8), "xx", Format(j - 12, "00")) 'Libelle Colonne H
.Range("C" & Fin) = tablo(i, 3) 'Debit = Nv Cpt = ColonneC
.Range("D" & Fin) = tablo(i, 11) 'Crédit =Cpte Abonnement =Colonne S ???
.Range("E" & Fin) = tablo(i, j) 'Montant
.Range("F" & Fin) = tablo(i, 6) 'Analytique = Colonne F
Next j
End If
Next i
End With
Application.ScreenUpdating = True
End Sub