Row/Cell timestamp in Excel 2010

I have a spreadsheet that a requirement is to Date/Timestamp (C2) a cell based on when the proceeding Cell (B2) is updated to the stored item “NMC”. The formula that I am using is as follows:
=IF(B2="NMC",IF(B2="NMC",NOW(),B2),"")
However, this formula works…too well… not only does that ROW timestamps, but all the other Rows with the same record changes as well. Or if I select any of the other two items (PMC or FMC) the timestamp will change immediately for any record with “NMC”.

I am a loss to how to fix this timestamp for the one record, not the others unless they are physically changed.

see the attached file
edrz01Asked:
Who is Participating?
 
tdlewisCommented:
Add this subroutine to the Worksheet in the Visual Basic Editor:
Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.value = "NMC" Then
        Target.Cells(1, 2).value = Now()
    ElseIf Target.value = "FMC" Or Target.value = "PMC" Then
        Target.Cells(1, 2).value = ""
    End If
End Sub

Open in new window

0
 
NorieVBA ExpertCommented:
How is the value in B2 updated?
0
 
edrz01Author Commented:
B2 is a pull-down with three selection "NMC", "PMC", "FMC"
It is selected by the user. I only want the "NMC" to timestamp, if either of the other two are selected...blank the timestamp in C.

Currently there are 94 records, if the user deems to change the status to NMC then datestamp, else NULL the timestamp.

Changing one row/record should not change any of the times in the other rows.
0
 
edrz01Author Commented:
Thank you very much tdlewis..!!! That's why you guys are the experts!! Perfect solution...!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.