Copying a portion of a row based on cell criteria to another sheet

Hello!

So I'm a newb at VBA programming, and I've been breaking my head over this code for some time now.

Originally, I'd gotten it to the point where it did copy just a portion of the row to the other sheet, but I forgot to save that copy of the code before I messed with it more and now it won't even do that.

So I have a column (M) that has a drop-down list with five conditions: Active, Pending, Completed, Early Termination and Disqualified.

I need excel, the second I press save, to scan the entire "M" column and find the cells with "Completed," "Early Termination," or "Disqualified" to copy the corresponding row from columns "A" to "J" and paste it in the corresponding sheets(same names as the categories) in the same workbook in the next open row. Then that row in the source sheet needs to be deleted.

This is what I have so far:

Please Login or Register  to view this content.

Thank you in advance!

lucky.vjn

Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

Remove "Set" from that line of code. Also, I see no reason for Status to be Variant, and recommend it be String.