Sub CréerNewligne()
Dim i As Long, NouvLigne As Long, Diff As Long, j As Long
With Sheets("BDD Clients")
For i = 1 To .Range("D65536").End(xlUp).Row
Diff = .Cells(i, 5).Value - .Cells(i, 4).Value
If Diff > 1 Then
NouvLigne = .Range("D65536").End(xlUp).Row + 1
For j = 1 To Diff - 1
.Cells(i, 1).EntireRow.Copy .Cells(NouvLigne + j - 1, 1)
.Cells(NouvLigne + j - 1, 4).Value = .Cells(i, 4).Value + j
Next j
End If
Next i
End With
End Sub