Sub Bouton1_Cliquer()
Dim dernLigneAcc As Integer
Dim dernLigneRefus As Integer
Dim dernlignecom As Integer
For j = 1 To ActiveSheet.Range("A65536").End(xlUp).Row
If ActiveSheet.Range("G" & j).Value = "Acceptée" And ActiveSheet.Range("G" & j).Interior.ColorIndex <> 4 Then
dernLigneAcc = Sheets("accepter").Range("A65536").End(xlUp).Row
For i = 0 To 10
Sheets("accepter").Range("A" & dernLigneAcc + 1).Offset(0, i).Value = ActiveSheet.Range("A" & j).Offset(0, i).Value
ActiveSheet.Range("A" & j).Offset(0, i).Interior.ColorIndex = 4
Next
Sheets("accepter").Range("A" & dernLigneAcc + 1).Offset(0, 10).Value = Now
ElseIf ActiveSheet.Range("G" & j).Value = "Refusée" And ActiveSheet.Range("G" & j).Interior.ColorIndex <> 3 Then
dernLigneRefus = Sheets("refuser").Range("A65536").End(xlUp).Row
For i = 0 To 10
Sheets("refuser").Range("A" & dernLigneRefus + 1).Offset(0, i).Value = ActiveSheet.Range("A" & j).Offset(0, i).Value
ActiveSheet.Range("A" & j).Offset(0, i).Interior.ColorIndex = 3
Next
Sheets("refuser").Range("A" & dernLigneRefus + 1).Offset(0, 10).Value = Now
ElseIf ActiveSheet.Range("G" & j).Value = "Validée mais à commander " And ActiveSheet.Range("G" & j).Interior.ColorIndex <> 8 Then
dernlignecom = Sheets("demandeacceptéacommander").Range("A65536").End(xlUp).Row
For i = 0 To 11
Sheets("demandeacceptéacommander").Range("A" & dernlignecom + 1).Offset(0, i).Value = ActiveSheet.Range("A" & j).Offset(0, i).Value
ActiveSheet.Range("A" & j).Offset(0, i).Interior.ColorIndex = 8
End Sub