Would like to delete rows based on cell content

Good Morning All,

The attached sample spreadsheet is divided into two sections. The top section is regular sales orders and the bottom section is non regular sales orders. I'm currently using the code below to delete rows based on color of column A. I would like to modify the current code to delete rows based on column A for regular sales orders only and to delete non regular sales orders based on SO status in column Q. Any non regular sales order with a SO status in column Q of A or S should be deleted with the macro. Any help is appreciated.

Please Login or Register  to view this content.

AlphaFrog,

Thanks for the quick response. There is just one issue. I only want to delete rows in the bottom half of the sheet based on content in column Q. Your code deletes all rows based on column Q.

AlphaFrog,

Perfect! Is there anyway to combine the macro for the top half and the macro you created. If I could have one macro for this sheet, that would be great. If thats too much I understand. Thanks for your time.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Works perfectly. Thanks so much for your help!