Try this
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim rng As Range
If Intersect(Target, Range("N:N")) Is Nothing Then Exit Sub
If Target.Count > 1 Then Exit Sub
Application.ScreenUpdating = False
Application.EnableEvents = False
If Target.Value = "Completed" Or Target.Value = "Committed" Or Target.Value = "Cancelled" Then
If Target.Offset(0, -12).Value = "" Then
With Target.Offset(0, -12)
.Formula = Now
.NumberFormat = "yy "
End With
End If
With Target.Offset(0, -13)
.Value = "TEAA"
End With
With Target.Offset(0, -11)
.Value = ActiveCell.Row - 1
End With
End If
Application.EnableEvents = True
Application.ScreenUpdating = True
End Sub
Cheers!!
Bookmarks