Delete a Row IF = certain value
 

On linked worksheets - in Monthly Sales Reports - I can link the OPEN orders
/data from the current month to the new month - BUT if an order has been
completed/shipped, how do I delete this order(which is displayed in 1 row)
automatically so it does not show up in the new month.

ie. All orders left open from the current month automatically go into the
new month via the links - as do all the SHIPPED orders. Is it possible to
STOP the SHIPPED orders from going to the new month, automatically...Thanks
for any help offered!

Using Excel in Office XP Pro