Bonjour à tous,
Ou encore la méthode longue ...
Sub Bouton1_Cliquer()
Dim B As Integer, Nc As Integer, WsNc As Worksheet, WsB As Worksheet, DligB As Integer, DligNc As Integer
Set WsNc = Worksheets("NoteCandidat") '' << dans ton fichier exemple ... c'est "NoteCondidat" ...
Set WsB = Worksheets("Base")
DligNc = WsNc.Cells(Rows.Count, "C").End(xlUp).Row
DligB = WsB.Cells(Rows.Count, "C").End(xlUp).Row
Application.ScreenUpdating = False
For Nc = 4 To DligNc
For B = 4 To DligB
If WsNc.Cells(Nc, "C").Value = WsB.Cells(B, "C").Value Then
WsB.Range(WsB.Cells(B, "F"), WsB.Cells(B, "G")).Value = WsNc.Range(WsNc.Cells(Nc, "E"), WsNc.Cells(Nc, "F")).Value
Exit For
End If
Next B
Next Nc
End Sub
ric