Sree lal Macro code for automatic change in next cell if particular data in leftside

Any one can help to find out the macro code for automatically come date at the right side when left side of cell is as "completed"?

Please Login or Register  to view this content.

I have tried the macro is not working... can do add it in the excel file and attached it. i need it in all the sheet 1.and tome should not change!!

Try to write "Completed" in column H

I need it for all the colum!in excel

Ok

Please Login or Register  to view this content.

can you include and attch file?

please check attachment