Automatic Time/Date Stamp When Neighboring Cell is Edited

[LabraLime]

Hello,

I have a live worksheet that several people work on and I am curious to see if there is a way to automatically enter a time/date stamp whenever a neighboring cell is updated.
For example if someone marks a N1 as "complete" then a time/date gets entered into cell Q1 so that we know when N1 was completed.

Thank you

 

[Momentman]

Hello,

I have a live worksheet that several people work on and I am curious to see if there is a way to automatically enter a time/date stamp whenever a neighboring cell is updated.
For example if someone marks a N1 as "complete" then a time/date gets entered into cell Q1 so that we know when N1 was completed.

Thank you

You can right click the sheet tab and select view code(this should be done on the sheet where the data is located

Add the following code

Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Range("N:N")) Is Nothing Then
        If Target.Value = "Completed" Then
            Target.Offset(0, 1).Value = Now
        End If
    End If
End Sub

The code assumes that the change will occur somewhere in Column N and the column just to the right will be updated accordingly

i am assuming that the word "Completed" will be typed or selected and is not generated by a formula