Hi,
How can I have a timestamp in cell B2 every time cell A2 change value.
Many thanks.
Dan

Hi,

Right click your sheet tab, view code and paste this in

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Cells.Count 1 Or IsEmpty(Target) Then Exit Sub

If Not Intersect(Target, Range("A2")) Is Nothing Then

Target.Offset(, 1).Value = Time

End If

End Sub

"Dan" wrote:

Hi,
How can I have a timestamp in cell B2 every time cell A2 change value.
Many thanks.
Dan

On Jun 17, 1:12*pm, Dan wrote:
Hi,
How can I have a timestamp in cell B2 every time cell A2 change value.
Many thanks.
Dan

Dan, u can get some help at http://www.mvps.org/dmcritchie/excel/event.htm#autodate

Thank you all, but I am looking for a formula not vba - this is why I have
put in my subject "circular reference" and also poseted it in the "Excel
Worksheet Functions" and not "Excel programming"

"Nayab" wrote:

On Jun 17, 1:12 pm, Dan wrote:
Hi,
How can I have a timestamp in cell B2 every time cell A2 change value.
Many thanks.
Dan

Dan, u can get some help at http://www.mvps.org/dmcritchie/excel/event.htm#autodate