Getting a row in sheet 1 to transfer to sheet 2 when the word yes is selected in a dropdow

Good day all.
Iam new to using excel and all it has to offer. I was wondering if anyone could help me. I would like to take a row of data and transfer it to sheet 2 once the guys select Yes from the drop down. If possible i would like to to leave sheet 1 and delete off it and only be on sheet 2. it is a small sheet it has a start date in column A and a finish date in column E. The Yes column is Column D. Once they select yes the date apears in column E and it is then completed. That is when i need it off sheet one and transfered to sheet 2. Any help is greatly appreciated.
Thanks
RR2105

Try:

Please Login or Register  to view this content.

This works well thank you. The only problem with it is you have to select the cell that says "YES" then hit enter to get it to transfer over to the other sheet. Also it does not remove the row that has been transfered to the second sheet. Is there a way to incorporate that into this.
Thanks in advance for the help
RR2105

Sorry it works fine excpt it does not delete the row on sheet one after it transfers it to sheet 2. Is there a way for it to do that and it woud be perfect.
Thanks
RR2105

You indicated that they will be selecting "Yes" from a drop down. The supplied code will work when that "Yes" value is selected from the drop down since it triggers a worksheet change event. Getting it deleted that row can be accomplished by adding one line:

Please Login or Register  to view this content.

I get an error now. Run-time error '13' Type Mismatch. If i click on debug it highlights the line in code that says If target.value = Yes then. If I click on END if transfers and deletes like it is supposed to. Is that because yes is a string?
Thanks
RR2105

Yeah that is my fault. I forgot to disable/enable "Enable Events". This should fix the problem:

Please Login or Register  to view this content.

Thank you for all the help it is appreciated. It works perfect.
RR2105