Hi all
I know this topic has been covered in past threads so apologies for bringing it up once again - Just having trouble getting it to work.
I have a task register that lists varying statuses in Column E. When 'Complete' status is entered, I need the entire row (Range A to L) to move to Sheet2. Sheet2 is a duplicate of Sheet1 but specifically for collating all completed tasks. Once the move event has occurred, the empty row should be deleted from Sheet1.
I should mentioned that I am using another Worksheet_Change event in the same Sheet that fulfills a different purpose.
Image attached.
Thanks for your help
I know this topic has been covered in past threads so apologies for bringing it up once again - Just having trouble getting it to work.
I have a task register that lists varying statuses in Column E. When 'Complete' status is entered, I need the entire row (Range A to L) to move to Sheet2. Sheet2 is a duplicate of Sheet1 but specifically for collating all completed tasks. Once the move event has occurred, the empty row should be deleted from Sheet1.
I should mentioned that I am using another Worksheet_Change event in the same Sheet that fulfills a different purpose.
Image attached.
Thanks for your help