Time stamp when a cell is changed

November 19, 2010 at 12:11:09
Specs: Windows Vista
I want a formula where when i type something in column A the date and time is shown in column B. For instance:
Column A Column B
0637a Date and Time
0637b different Date and time

I just don't want the time of the previous to change when I put new information in column A.

See More: Time stamp when a cell is changed

Report •

November 19, 2010 at 12:30:03
In order to hard code a date/time in a cell you need to use a macro.

Right click the sheet tab for the sheet in which you want this to happen and paste the following code into the pane that opens.

Private Sub Worksheet_Change(ByVal Target As Range)
 If Target.Column = 1 Then Target.Offset(0, 1) = Now
End Sub

Posting Tip: Before posting Data or VBA Code, read this How-To.

Report •
Related Solutions

Ask Question