time stamp

[Ralter649]

When I enter something in to O2 I want P2 to show the date/time it was entered. I have =IF(O2<>"",IF(P2<>"",P2,NOW()),"") and it works (kinda) but I want it to update the date/time if I enter new or change the info in cell O2, it will work if I delete the info and re-enter it but I would like to just be able to overwrite it and have it change. (I have gone to FILE - OPTIONS - FORMULAS - and enabled interactive calculations) I need this to work for the whole column by row, a lot of the formulas I have tried change every date/time in column P instead of just the one for that row

thanks for any help you can lend

 

[My Aswer Is This]

If you want a Vba solution try this:
This is an auto sheet event script
Your Workbook must be Macro enabled
To install this code:
Right-click on the sheet tab
Select View Code from the pop-up context menu
Paste the code in the VBA edit window

Private Sub Worksheet_Change(ByVal Target As Range)
'Modified  9/21/2018  1:26:21 AM  EDT
If Not Intersect(Target, Range("O:O")) Is Nothing Then
If Target.Cells.CountLarge > 1 Or IsEmpty(Target) Then Exit Sub
If Target.Row > 1 Then Target.Offset(, 1).Value = Now()
End If
End Sub