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.
Most easy approach would be that
you have a column that keeps the status. When ever you are ready
you can fillter the sheet on "complete" status
copy all the visible rows to other sheet
delete all the visible rows