Sub enreg_broyage()
Dim lig As Long, i As Integer
With Sheets("Suivi broyage")
lig = .Range("A" & Rows.Count).End(xlUp).Row + 1
For i = 2 To 9
.Cells(lig, i).Value = Cells(5, i).Value
Next
.Range("J" & lig).Value = Range("C8").Value
.Range("K" & lig).Value = Range("D8").Value
.Range("L" & lig).Value = Range("E8").Value
.Range("M" & lig).Value = Range("F8").Value
.Range("N" & lig).Value = Range("G8").Value
.Range("O" & lig).Value = Range("H8").Value
.Range("P" & lig).Value = Range("I8").Value
End With
Range("C5:F5").ClearContents
Range("H5:I5").ClearContents
Range("D8:G8").ClearContents
Range("I8").ClearContents
End Sub