Bonjour Nonno, Dan, le forum,
Un essai ...
À placer dans la feuille concernée ...
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
If Intersect(Target, Range("A5:A30")) Is Nothing Then Exit Sub
Range("C1").Value = Target.Value
End Sub
ric