Date Stamp one column based on set data in another column

Hi HACCStaff,

You can try a solution using like this. I would first of all set up an event triggered macro in either the worksheet module (if you only want this to work on the particular sheet only) or the Thisworkbook module (if you want it to work on all sheets in the workbook). Assuming you only want to get it to work on a particular sheet, right click on the sheet tab and chose View code. Then paste this in:

Please Login or Register  to view this content.

If you type a 1 in cells A1 to A10 then the next column should write the date for you.

Hi J450n,
Unfortunately nothing changed. No dates appeared. I changed the 1 to Completed. I have also put more information in post. I am working on a single worksheet.
Thanks for your help

Hi again,

I tested the code on a blank workbook before I posted it and it worked fine. Maybe you should try that 1st too, and see if it triggers ok.
Did you paste this into your actual sheet, if so did you remember to change the intersect area from range("A1:A10") to the actual range you need???
If you do try this in a new sheet, and nothing happens, have you at some stage turned off the event trigger? if so you need to run "Application.EnableEvents = True" to reset the mode i think.
Hope this helps.

press alt + F11, then Ctrl + G. type or paste in Application.EnableEvents = True and hit enter. That should do it . Else you can make up a simple sub() and put it in there and run it.
Hope this solves it for you, as i have to go offline very shortly. Good luck.

Last min before i'm away!
try this instead:

Please Login or Register  to view this content.