Trasferring data when certain value entered into cell

Hi,

I have a workbook where I want to fill in information and tab "Ongoing" and once Yes is entered into the column H I want to create a macro to send that row of data to the "Completed" tab and delete from "ongoing".

Is this something anyone can help with?

Thanks

Try the attached.

thanks very much seems to work great, can you tell me what you have done?

I have put the code in sheet ongoing. The code is triggered when you make changes to column H. It copies that row which has been changed and it also deletes it from sheet on going once that row has been copied.
You need to change the status to Yes if you want to run the code.