Inserting Dates based on Cell changes and Selection criteria of Status

[tharveen]

Hello Experts,

Seeking out for a code :


Criteria :

1) When program name is type ( as long as it is a text) automated date with time should be inserted in column "Date Received".

2) On status there is few items in format of drop down list. Every time a particular status is selected then respective column will capture the date.

##Please see the table below ( I am not sure how to upload picture here ####



Appreciate if someone can help me out to create the macro for this.


Please let me know if you need more information.


Thank you.

Regards

Tharveen.

[TABLE="width: 1109"]
<TBODY>[TR]
[TD]#</SPAN>[/TD]
[TD]Program ID</SPAN>[/TD]
[TD]Program Name</SPAN>[/TD]
[TD]# Underlyers</SPAN>[/TD]
[TD]MAS Program Specialist</SPAN>[/TD]
[TD]Date Received</SPAN>[/TD]
[TD]Status</SPAN>[/TD]
[TD]Date Completed</SPAN>[/TD]
[TD]Date Clarification Return to UK

</SPAN>[/TD]
[TD]Date Error Return to UK</SPAN>[/TD]
[TD]Comment</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]1</SPAN>[/TD]
[TD]3222332</SPAN>[/TD]
[TD]COOPERATIVE NOVA ARGENTA U.A</SPAN>[/TD]
[TD]2</SPAN>[/TD]
[TD] [/TD]
[TD]6-19-14 1:06 PM</SPAN>[/TD]
[TD]Clarification UK</SPAN>[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</TBODY><COLGROUP><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP>[/TABLE]