VBA Helpo

[debneedshelp]

I am trying to find a way to move multiple rows from a master "Open orders" sheet to the corresponding sheet based on the selection for status column (either Closed or Glass Here).

Basically - if Closed is selected in the Status column, move that row to the Closed Orders Sheet and delete from Open Orders
If Glass Here is selected, I want to move it to the Glass Here Sheet and delete from Open Orders

Now here is where it gets interesting...is there a way once I have the data or row in the Glass Here sheet, if I choose Closed within that sheet, I need it to also move it to the Closed Orders and delete from the Glass Here Sheet...

HELP!!!!

 

[debneedshelp]

Also, if there is a way to keep the data in order from smallest work order number to largest that would be helpful as well...see sample