Bonjour,
A mettre dans le module de la feuille car procédure événementielle :
Private Sub Worksheet_Change(ByVal Target As Range)
Dim Plage As Range
Dim Cel As Range
With ActiveSheet: Set Plage = .Range(.Cells(4, 5), .Cells(.Rows.Count, 5).End(xlUp)): End With
Set Cel = Plage.Find(Target.Value, Plage(Plage.Count), xlValues, xlWhole)
If Not Cel Is Nothing Then
Application.EnableEvents = False
Cel.Offset(, 2).Value = Cel.Offset(, 2).Value + 1
Target.Value = ""
End If
Application.EnableEvents = True
End Sub
puis enregistrer en .xlsm !