Time with entering data in the corresponding cell

[Amit Kumar Baidyaka]

Hi, can someone help me in......I have some columns in a sheet with filled
data in column a, b & c. I have column d, e & f are blank and then I have
column g, h & I to study time. Now what my requirement is that just as I
start entering data into any of the blank column (d, e or f) it should take
start time in column "g". this will really help me a lot if some automation
could be possible.
Thanks in advance.Amit.

 

[Stefi]

Apply this event sub:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column >= 4 And Target.Column <= 6 Then Range("G" &
Target.Row).Value = Date + Time
End Sub
Post if you need help to install it!
Regards,
Stefi


„Amit Kumar Baidyaka†ezt írta:

 

[Bob Phillips]

Now = Date + Time

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Stefi]

Thanks Bob, though it's simple and logical, it was a new revelation for me!
Stefi


„Bob Phillips†ezt írta: