Sub Duplique()
Dim TE(), LE&, TS(), LS&, C&
TE = ActiveSheet.[A1].CurrentRegion.Value
ReDim TS(1 To 5000, 1 To 9)
For LE = 2 To UBound(TE, 1)
LS = LS + 1
For C = 1 To 6: TS(LS, C) = TE(LE, C): Next C
TS(LS, 8) = TE(LE, 8)
If Not IsEmpty(TE(LE, 7)) Then
LS = LS + 1
For C = 1 To 5: TS(LS, C) = TE(LE, C): Next C
TS(LS, 6) = TE(LE, 7): TS(LS, 8) = Now
TS(LS, 9) = "Nouveau": End If: Next LE
ActiveSheet.[A14].Resize(LS, 6).Value = TS
End Sub