Set ShComm = Sheets("Commande")
With Sheets("Reversement")
.Range("A11:X40").ClearContents 'pour supprimer les lignes de 11 à 40 et les colonnes de A à X
Dim lig As Long
For lig = 9 To ShComm.[A8].End(xlDown).Row
.[O3].Value = ["POUR LE MOIS DE "] & [B1].Value
.[V43].Value = [B2].Value
.Range("A" & lig + 2).Value = ShComm.Range("A" & lig).Valu
.Range("B" & lig + 2).Value = ShComm.Range("B" & lig).Value
.Range("C" & lig + 2).Value = ShComm.Range("C" & lig).Value
.Range("D" & lig + 2).Value = ShComm.Range("E" & lig).Value
.Range("E" & lig + 2).Value = ShComm.Range("G" & lig).Value
.Range("F" & lig + 2).Value = ShComm.Range("H" & lig).Value
.Range("G" & lig + 2).Value = ShComm.Range("I" & lig).Value
.Range("H" & lig + 2).Value = ShComm.Range("K" & lig).Value
.Range("J" & lig + 2).Formula = "=F" & lig + 2 & ("+G" & lig + 2) & ("+H" & lig + 2) & ("+I" & lig + 2)
.Range("K" & lig + 2).Formula = "=Round(F" & lig + 2 & "* 1 / 3,2)"
.Range("L" & lig + 2).Formula = "=Round((G" & lig + 2 & "+H" & lig + 2 & ")* 10 / 100,2)"
.Range("M" & lig + 2).Formula = "=Round(IF((sum(RC[-2]:RC[-1]))>(Commande!R3C2*0.5),0,((Commande!R3C2*0.5)-(sum(RC[-2]:RC[-1])))),2)"
.Range("O" & lig + 2).Formula = "=Round(IF(=L" & lig + 2 =["oui"],Commande!" & [B3].Address & "*20/100,0,2))"
.Range("P" & lig + 2).Formula = "=K" & lig + 2 & ("+L" & lig + 2) & ("+M" & lig + 2) & ("+N" & lig + 2) & ("+O" & lig + 2)
.Range("Q" & lig + 2).Value = ShComm.Range("Y" & lig).Value
.Range("R" & lig + 2).Value = ShComm.Range("W" & lig).Value
.Range("S" & lig + 2).Value = ShComm.Range("R" & lig).Value