Private Sub Worksheet_Change(ByVal Target As Range)
Dim n
If Target.Address = Range("c1").Address Then
On Error Resume Next
n = Application.Match(Format(Date, "dd/mm/yyyy"), Columns("b:b").Value, 0)
If Not IsError(n) Then Cells(n, "c") = Target.Value
End If
End Sub