paste the code in the worksheet event (right click on sheet tab > view code)
whenever any value updates in column K, current time will insert in col N![]()
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 11 Then Target.Cells.Offset(, 3) = Time End If End Sub
Bookmarks