Sub Macro1()
Dim O As Worksheet
Dim TV As Variant
Set O = Worksheets("Feuil1")
TV = O.Range("A1").CurrentRegion
For i = 2 To UBound(TV, 1)
If TV(i, 1) = TV(i, 4) Then
TV(i, 5) = TV(i, 2)
TV(i, 6) = TV(i, 3)
Else
If TV(i, 2) = TV(i, 4) Then
TV(i, 5) = TV(i, 1)
TV(i, 6) = TV(i, 3)
Else
TV(i, 5) = TV(i, 1)
TV(i, 6) = TV(i, 2)
End If
End If
Next i
O.Range("A1").Resize(UBound(TV, 1), UBound(TV, 2)).Value = TV
End Sub