Trying to find a solution for my specific problem searching on the web, I found many interesting solutions for cut and paste rows from one sheet to another, but I need the rows back to the original sheet when the project is completed:

I have a list of projects in one sheet named MASTER and want to move the specific rows to the sheet OPEN (when a project is still open, it means in progress). When a project is completed, this project (specific entire row) must move back to MASTER sheet. I am not an expert at all in excel and macros, VBA, programming in general... and the most straight forward and simple solution would be the best.

Could be something like when the last column is checked, it would move the open project (the row) from sheet MASTER to sheet OPEN (then I would need to learn how to insert the check box...) and when unchecked the row would go back to sheet MASTER OR a regular last column when you enter the word "OPEN" it would move the open project (the row) from sheet MASTER to sheet OPEN automatically and when you enter completed or whatever the row would go back to sheet MASTER. Or maybe someone could come up with a much better solution.

Thank you very much in advance for any help,

Fer