Trying to move a row from one sheet to another based on a cells status

Hi there!

I am working on a worksheet, and would like to have an entire row transferred to another sheet based upon a certain cell's value.

I have one sheet named Open Projects and I would like if once a project becomes (Column K) "complete" the row of information regarding that project is moved to the Closed projects worksheet.

Can anyone help me install or create a macro that can perform that function.


I would like all completed work to be deleted from the Open Project sheet, and transferred to the Closed projects worksheet that contains a running list of all completed projects.

Attached is an example of what I am working on. I would like Column K (Status) to determine if a row can be moved to a sheet that contains the list of all work completed, and eliminated from the original sheet.

Can anyone help?


Thanks!

Watch this video.

https://www.youtube.com/watch?v=fxgQm32sBeI