Sub MAJ_rapport()
'PremiereLigneRapport = Sheets("Rapport").Range("A:A").End(xlDown).Row + 1
PremiereLigneRapport = Sheets("Rapport").Cells(Rows.Count, 1).End(xlUp)(2).Row
NbligneaCopier = Sheets("Feuil1").Range("A6:A1000").End(xlDown).Row - 5
For i = 6 To 5 + NbligneaCopier
[Rapport].Cells(PremiereLigneRapport, 1) = [DateEnCours] 'Date
[Rapport].Cells(PremiereLigneRapport, 2) = [OF] 'OF
[Rapport].Cells(PremiereLigneRapport, 3) = [NoSemaine] 'Semaine
[Rapport].Cells(PremiereLigneRapport, 4) = [Quantite] 'Qté
[Rapport].Cells(PremiereLigneRapport, 5) = Sheets("Feuil1").Range("A" & i) 'Code
[Rapport].Cells(PremiereLigneRapport, 6) = Sheets("Feuil1").Range("B" & i) 'Désignation
[Rapport].Cells(PremiereLigneRapport, 7) = Sheets("Feuil1").Range("F" & i) 'Poids
[Rapport].Cells(PremiereLigneRapport, 8) = Sheets("Feuil1").Range("G" & i) 'Qté UVC
PremiereLigneRapport = PremiereLigneRapport + 1
Next i
End Sub