Automatic Timestamp question/help

[matt179]

Hello,

Im a complete novice at excel, i know a few basic functions and thats all and need help creating an automatic timestamp.

I need a function or a macro to insert the Time automatically into collumn D2 after ive inserted text into C3, once this timestamp is inserted i dont want it to change if you edit any of the text in the line.

I dont know how to do complex things in excel so if someone knows how to do what i want and could help me out, might need some help explaining if its complex but i would greatly appriciate it.

Thanks in advance...

 

[VoG]

Try this: right click the sheet tab, select View Code and paste in

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address(False, False) = "C3" And Range("D2").Value = "" Then
    Application.EnableEvents = False
    Range("D2").Value = Now
    Application.EnableEvents = True
End If
End Sub

 

[matt179]

That works great, although i dont want the date just the time if possible?

And what i need is for this to work for every D column, so if i input data into C column, e.g. C42 it'll put the time into C42 and so on.

As i have multiple sheets, 7, 1 for each day, can you just copy and paste it onto each individual sheet?

 

[VoG]

Try this - you can use this on as many sheets as you wish

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 3 And Target.Offset(, 1).Value = "" Then
    Application.EnableEvents = False
    Target.Offset(, 1).Value = Time
    Application.EnableEvents = True
End If
End Sub

 

[matt179]

Thank you ever so much, its PERFECT!!!