Sub MAJ()
With Sheets(1)
ligne = ici(.Columns(1), Range("E3"), Range("G3"), 1).Row
For j = 3 To 12
.Cells(ligne, j) = Cells(7, j)
Next
End With
End Sub
Function ici(plage As Range, valeur1 As Variant, valeur2 As Variant, decalage As Integer) As Range
Set ici = Nothing
With plage
ok = False
Set ici = .Find(valeur1, LookIn:=xlValues)
If Not ici Is Nothing Then
prem = ici.Address
Do
If ici.Offset(0, decalage) = valeur2 Then ok = True
If Not ok Then Set ici = .FindNext(ici)
Loop While Not ici Is Nothing And ici.Address <> prem And Not ok
End If
End With
End Function