that macro works but any newly completed tasks just overwrite the first entry on the completed worksheet. Any code to make sure that the next completed task gets written on the first available empty row. Also, it won't work if the task worksheet is protected. What code do I need to be able to unprotect the sheet to remove the completed row and then re-protect the sheet?

TIA
Nicki