call a macro if value in particular column is either of 2 specific values
Code
If Target.Count > 1 Then Exit Sub
If Not Intersect(Target, Range("O:O")) Is Nothing Then
Application.ScreenUpdating = False
If Not Target.Value = "D. DUTY" Then
Exit Sub
Else
Application.EnableEvents = False
Call CopyDownRows
Application.EnableEvents = True
Application.ScreenUpdating = True
End If
End If
Display More
in this macro, macro copydownwards is called if "D. DUTY" is entered in any cell in column "O"
i want to extent it for values "SPM DUTY" as well as "D. DUTY"