Excel Automatically move entire rows from one Worksheet into another Worksheet in the same Workbook
I have a Task List Workbook (with 2 Worksheets) Worksheet 1 will be just for Open Task Items. Worksheet 2 will be just for Closed Items. Worksheet 1 will consist of rows of Open Items. The last column for each row on Worksheet 1 will either be a checkbox (for task completed) or a cell that we type a "completed date" into. Once the last column cell is checked as completed or the cell is populated with a complete date, is there a way to have that be the trigger for the entire row to transfer over (be cut) from Worksheet to Worksheet 2 of the same Workbook? Again, Worksheet 1 will be just for Open Task Items and Worksheet 2 will be just for Closed Items. Thank you for your help.
This question generated 39 answers. To proceed to the answers, click here.