Now function to stop if

[CocaN]

Hi,

I have an excel were I need into one column to stop the function now to count and freeze the value if other column is filled with DA or NU. Bellow I putted a link with the excel. So I need the cell from column D (Done time) to stop if in the cell from column E (Status) is filled with DA or NU, otherwise to continue counting. Hope I explained very clear what I need

http://www.easy-share.com/579B025CE6D611E09676002481FAD55A/Test_cond.xlsx

 

[VoG]

Try this: right click the sheet tab, select View Code and paste in

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 4 Then
    If Target.Value = "DA" Or Target.Value = "NU" Then
        Application.EnableEvents = False
        With Target.Offset(, -1)
            .Value = .Value
        End With
        Application.EnableEvents = True
    End If
End If
End Sub