Hi again Dlomas,
Okay, if you just want to capture manual entries, this is very easy. Here's sample code that will record in column C the date that any value in Column B is manually edited. Be sure to format column C in a date format.
Install this code in the worksheet's event code module. To do this, right-click on the worksheet tab, select View Code, and paste this code into the VBE code pane that appears, and voila!
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 2 Then
'store current date/time in column 3
Cells(Target.Row, 3) = Now()
End If
End Sub
If you want to further restrict this routine to looking at just on a certain range of rows in column 2, the If test would look like:
If Target.Column = 2 AND Target.Row > 5 AND Target.Row < 20 Then
Which would look at only B6:B19. Much more complex ranges can be accommodated using the Intersect function.
Enjoy and