Help required

[Chantty]

Hi Folks,

Let me explain my requirments.

If column "A" typed/edited then in current time & date has to be captured in column "B"

i.e

A1 = "Target 1" then
B1 = "14-Apr-2008 15.25"

Cheers

 

[Peter_SSs]

Remembering that everybody who asks a question requires help, a more descriptive title would help attract people with knowledge about your particular issue.

See if this is some help. If not, use the search facility at the top to look for date stamp or time stamp as this sort of question has been asked many times.

http://www.mrexcel.com/forum/showthread.php?t=299322

 

[schwede]

Chantty,

take a look at this link: http://www.mcgimpsey.com/excel/timestamp.html

Your best option is probably the worksheet event macro although these functions should be used with care.

Hope it helps,
Schwede