Move row to another sheet based on value

[gregoryspeters]

Hi everyone,

I need to move rows with a "Yes" designation in column V in the "manual data" tab into a separate "completed" tab. I was hoping to move them with a macro using a button because new data is posted into the spreadsheet each week. I do not have a great background with macros and tried to write/develop a module, but I continued to receive errors. Additionally, when the rows are moved, I would like for the moved rows to be deleted from the "manual data" sheet and all remaining rows to be moved up. I have included a sample of the spreadsheet. Please let me know if you are able to help me out. I appreciate your help!

[gregoryspeters]

File included here:

[kvsrinivasamurthy]

Pl see the attached file with macro TransferToCompleted().

[gregoryspeters]

Thanks! This works great, but if I run the macro after all "Yes" rows have been moved to the "completed" tab, the "No" rows move to the "completed" tab as well. Why is this occurring when running the macro?