Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
If Not Intersect(Target, Range("B2:B1000")) Is Nothing Then
If Target = "OK" Then
Range("D" & Target.Row) = Range("C" & Target.Row)
Range("C" & Target.Row) = 0
End If
If Target = "NOK" Then
Range("D" & Target.Row) = Range("C" & Target.Row)
Range("C" & Target.Row) = Range("C" & Target.Row) + 1
End If
End If
End Sub