Sub Macro1()
Dim ValeurCellule
Dim i
For i = 1 To 20
Worksheets("Feuil1").Activate
Set ValeurCellule = Range("A" & i)
ValeurCellule.Select
Rows(ActiveCell.Row).Select
Selection.Copy
Worksheets("Feuil2").Activate
Columns("A:A").Select
On Error Resume Next
If Selection.Find(ValeurCellule, LookIn:=xlFormulas, LookAt:=xlPart).Activate = ValeurCellule Then
Else:
Worksheets("Feuil3").Activate
Rows(i & ":" & i).Select
ActiveSheet.Paste
End If
On Error GoTo 0
Next i
Application.CutCopyMode = False
End Sub