D Dan Jun 17, 2008 #1 Hi, How can I have a timestamp in cell B2 every time cell A2 change value. Many thanks. Dan
M Mike H Jun 17, 2008 #2 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
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
N Nayab Jun 17, 2008 #3 Hi, How can I have a timestamp in cell B2 every time cell A2 change value. Many thanks. Dan Click to expand... Dan, u can get some help at http://www.mvps.org/dmcritchie/excel/event.htm#autodate
Hi, How can I have a timestamp in cell B2 every time cell A2 change value. Many thanks. Dan Click to expand... Dan, u can get some help at http://www.mvps.org/dmcritchie/excel/event.htm#autodate
D Dan Jun 17, 2008 #4 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"
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"
