Auf Hilfe hofft
Wolfgang
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Dim a, gg As Integer
Dim dd As Date
gg = Range("A65536").End(xlUp).Row
dd = Cells(gg, 1)
a = ActiveSheet.Cells(Rows.Count, 2).End(xlUp).Row
If Not Intersect(Target, Cells(a, 2)) Is Nothing Then
Cells(a, 2).Offset(18, -1) = dd + 1
End If
End Sub