VBA/Macro to remove rows if two conditions are met

Hi there, I need to delete rows where the cells in column b "UnitID" contain "80BUILD" AND the cell in column F (CompType) = 14 - I know I can use auto filter, but it would be much easier to do this at the push of a button (so to speak!).

Any ideas/thoughts!


Thanks in advance of your amazing help

Cheers
Emma

Well, you can attach the fillter code to a button, so push the button.

Thanks AB33 - I've just managed to link a button to alansidman's code!