Put this code in your worksheet module. To do this, right click the sheet
tab at the bottom of Excel, click View Code, then paste code below into the
sheet module. This code will put a time stamp in Col. D if any data is
changed in columns A, B, or C. Give it a try. Hope this helps! If so, let
me know, click "YES" below.

Private Sub Worksheet_Change(ByVal Target As Range)

If Not Intersect(Target, Range("A:C")) Is Nothing Then
Cells(Target.Row, "D") = Format(Now, "mm/dd/yyyy - hh:mm:ss")
End If

End Sub

--
Cheers,
Ryan


"moonhk" wrote:

Hi All
I want to keep trace some of cells in Row have been updated, the one
of column update as today and time ? Does formula can handle this ?

eg. A11 or B11 or C11 Updated, the D11 = today + time


moonhkt
.