>Two columns in my worksheet need to work as follows:
>When Column N gets filled in, Column M needs to automatically get the current date. So, if Column N gets filled in today, Column M would have today's date. Tomorrow, Column M would still have today's date.
>
>How can I do this?
>
>Jerry


Hi Jerry,

See if it helps:

Private Sub Worksheet_Change(ByVal Target As Range)
    If Selection.Column = 14 Then       'Column N
       Cells(Selection.Row - 1, 13).Value = Now
    End If
End Sub

Good Luck