Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time with entering data in the corresponding cell
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time with entering data in the corresponding cell
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: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time with entering data in the corresponding cell
Now = Date + Time
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Stefi" wrote in message ... 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: 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time with entering data in the corresponding cell
Thanks Bob, though it's simple and logical, it was a new revelation for me!
Stefi €˛Bob Phillips€¯ ezt Ć*rta: Now = Date + Time -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Stefi" wrote in message ... 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: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Entering a random date and time in a cell | Excel Discussion (Misc queries) | |||
How to mark down the time when entering input to a cell? | Excel Worksheet Functions | |||
How to mark down the time when entering input to a cell? | Excel Discussion (Misc queries) | |||
entering time data | Excel Discussion (Misc queries) | |||
Formula is entering a default time when it comes across an empty cell.. | Excel Worksheet Functions |