Move Data from one tab to another in same worksheet

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.

Originally Posted by Richard Buttrey

Have you tried using the Data Advanced Filtering functionlity

Upload the workbook and manually add some expected results if you need some additional help.

Thank you mate! I've never used DAF. I'm only now just starting my jaunt with VBA as I never had the need. But, necessity is the mother of invention, right?

Where / how would I upload the sheet?

I have found some scripts that would do partial parts of what I need. They would move the data but perhaps not all of it. The entire row would be fine. But, seemed the catch was always to delete the original line from the source tab.

Thanks!

The two tabs I'd like to work with are "Main" and "Complete". There's also a "Data" one but that's just a source for data for pull down's in "Main".

So when the condition of "Complete" is met of column "O" (Status), I'd like the script to move the entire row to the "Complete" tab, AND remove it from "Main".

And, as new items are completed, I'd like them to be added to the Complete tab so, don't replace stuff, just append.

Many thanks!

Dan

Sintek, thank you!!

You've gotten me 99.99% of the way there. Only problem is it appears that the data moved to "Completed" didn't start with column A from "Main". Some stuff is missing (IE Date) and items are sku'd one column over.

Dan

Actually this worked!!
I must have been on a starting column other than A.

Much appreciated!