You can do this with VBA
Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
'don't use multi cell selections
If Target.Count > 1 Then Exit Sub
Application.EnableEvents = False
Cells(Target.Row, Columns.Count).End(xlToLeft).Offset(0,1).Value = Now
Application.EnableEvents = True
End Sub
Worksheet event code is stored on a worksheet module. To add it to your worksheet, do the following:
Copy the code that you want to use
Select the worksheet in which you the code to run
Right click on the sheet tab and choose View Code, to open the Visual Basic Editor.
Check that the left hand drop down is set to WorkSheet
Where the cursor is flashing, choose Edit | Paste
Bookmarks