1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| Private Sub CommandButton1_Click()
i = 1
For Each cel In Range("A1:A10")
For Each celbis In Worksheets("Feuil2").Range("A1:A10")
If cel = celbis.Offset(0, 2) And cel.Offset(0, 1) = celbis.Offset(0, 3) And cel.Offset(0, 4) <> celbis.Offset(0, 5) Then
Rows(cel.Row).Copy
Worksheets("Feuil3").Activate
Worksheets("Feuil3").Rows(i).Select
ActiveSheet.Paste
i = i + 1
Worksheets("Feuil2").Activate
Worksheets("Feuil2").Rows(celbis.Row).Copy
Worksheets("Feuil3").Activate
Worksheets("Feuil3").Rows(i).Select
ActiveSheet.Paste
i = i + 1
Worksheets("Feuil1").Activate
End If
Next
Next
End Sub |
Partager