Time stamping a row

[mnovom]

I want a formula that will automatically put a time stamp in whenever I make a change to a certain row. For example: If I have people's names in going down in Column A, I would like the time stamp column to be in Column B. Then whenever I add new information about the person in Columns C, D, E, F, etc. the time stamp in Column B will show the day and time of the most recent entry.

Is this possible? Please help.

Mark

 

[RickXL]

Hi and welcome to the forum,

You could try this:

Private Sub Worksheet_Change(ByVal Target As Range)
    Application.EnableEvents = False
    Range("B" & Target.Row).Value = Now()
    Application.EnableEvents = True
End Sub

You will need to paste it into the macro space for the worksheet you are using e.g.Sheet1.

Every time a change is made to the worksheet that macro will run.

    Range("B" & Target.Row).Value = Now()

Is the one that writes the date and time now into column B in the cnanged row.

    Application.EnableEvents = False

is required to stop that change re-triggering the macro because writing a number into column B is a change. Without that line the macro gets stuck in a loop until it runs out of resources.

Setting it to True at the and switches the events back on so the next change will be picked up.