Automated Task Sheet

[UDLearning]

Hi,

I've created a task management worksheet with an additional tab for completed tasks.
Is there a way to have an automation that will move an entire row from the 'Active tab' to my 'Completed tab' when I change the Status column ($D:$D) to Complete?

It will need to cut the entire row and move it to the completed tab in the next row with no text.
I'd prefer to avoid using a Macro if possible.

Thanks!

 

[GWteB]

Hi UDLearning, welcome to this forum!

It will need to cut the entire row and move it to the completed tab in the next row with no text.
I'd prefer to avoid using a Macro if possible.

That is not possible, it requires VBA. Perhaps you can take a look over here, your question is very similar to that topic.