Hello!
I am updating a document for work and which shows projects being worked on and their status.
I would like rows which have been marked as "Archive" to be automatically moved onto another worksheet so as not to clog up the current work. How do I input a code to enable that to work properly? I'm pretty new to this and would love some help. I attached a screenshot to show the document.
Working Sheet would be "Project Status 2.0" and the rows to be moved to ARCHIVE
Thank you!
I am updating a document for work and which shows projects being worked on and their status.
I would like rows which have been marked as "Archive" to be automatically moved onto another worksheet so as not to clog up the current work. How do I input a code to enable that to work properly? I'm pretty new to this and would love some help. I attached a screenshot to show the document.
Working Sheet would be "Project Status 2.0" and the rows to be moved to ARCHIVE
Thank you!