• Hot Topics

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.

This thread is current as of January 3, 2012.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel


© Copyright 2018 excelarticles.com.