Delete rows if column A matches number and meets condition in another column

Good evening all,

I have a macro which currently auto filters and copies to another sheet but the problem I have is that I have orders on 2 or more rows. If one line does not meet a condition in a different column (potentially more than 2 columns) I need it to delete the entire order.

I have attached a little sample sheet, column A has an order number but for example if the condition in column K was to delete any row containing "Digital Print - Glass" is it possible to then match the order numbers and delete both rows?

I hope my babbling makes sense but I just wondered if it was possible

Any help is much appreciated this is a little advanced for me

Hi Olly

Thanks for the quick reply!

It works well and I have tested it changing the condition but can't seem to get it using multiple conditions in column K.

Sorry I meant to say it should delete order numbers and where they have several values from K ("Digital Print - Glass" and / or "Digital Print - DCT" and / or "Digital Print - Ceramic") The amended formula works good thanks I'll try to add something simular to the end of my vba

Cheers for the help

Top man! That's worked perfectly!

Thank you for your help its much appreciated