I have run into a scenario that may help myself and fellow coworkers. I believe there is a way to do this but I personally don't know how to make it work.
I have a list of tasks that needs to be complete, and its an ongoing list. I would like to make a column called "completed" and when someone completes the task they write completed in the column and it will take that entire row and move it to another sheet. Making the Sheet 2 completed tasks only, that way the first sheet will be tasks that still need to be completed.
My original thoughts:
1. If statement, but thought maybe it would be hard to move the entire row.
2. Macro, I really haven't worked with macros enough to create something like this.
Thanks in advance!
Bookmarks