Excel - A macro to move data to another worksheet

October 2016


I'm looking for support to create a condition based macro to copy rows from one worksheet to another in Excel.
  • I'm trying to create a To-Do workbook where-in I want to move my completed task to another worksheet of the same workbook.
  • Any ideas would be deeply appreciated as I do not have much experience with VBA.


The easiest approach would be:
  • You have a column that keeps the status.
  • You can filter the sheet on "complete" status
  • Copy all the visible rows to other sheet
  • Delete all the visible rows

Related :

This document entitled « Excel - A macro to move data to another worksheet » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.