Greetings and thanks in advance for any assistance.

I have a SS that we track RMA's on. I'd like to be able to have a VBA script that would, upon changing the "Status" column to "Complete", would move from this "Main" Tab to a "Complete" tab, AND removing from the original automatically.

In this case, the Status column is column "O"

Thanks.