Formula or Macros that will poulate a date in one cell as soon as I start to type another

[Squint]

I am hoping that this is possible. I will be attending some all day meetings over the next few weeks and possibly even months that will require keeping very close track of several conversations and when they occurred. The date and time of each discussion would be very helpful. Normally I would not use Excel for meetings but I am going to use excel because down the road it will help to be able to filter and possibly even create pivot tables capabilities. I am attaching a sample I have created. If there is either a formula or a macros that I could create or copy that would automatically insert that date and time in A2 as soon as I begin to type in B2 that would do the same for the remaining cells in column A and B this would save me a lot of time when topics may be changing quickly.

Thanks to anyone that may have a solution.

[Richard Buttrey]

Hi,

The attached contains the following Sheet Change Macro which puts the Date & Time in column A

Please Login or Register  to view this content.

[Squint]

I'm not sure if I am doing something wrong. I opened your attachment and when I type in column B there is nothing populated in column A. Is that how it is supposed to work?

Thanks for your help.

[Glenn Kennedy]

Enable macros on opening....