VBA Excel: Identifying a row, then comparing columns in that row and deleting duplicates

The aim in mind is to identify a row that has 'US Control Injection'
Then compare cell A, Cell F, Cell H and Cell O with all other rows.
Any rows that match all 4 of these cells can then be deleted along with the originally identified row.
I need to match so many cells as these can differ and i may not want to remove them.

Attached is an example file (Obviously with sterilised data)
If the code works properly then I would expect Rows 7,8 and 11,12 to be removed but all others to remain.
Apologies for not having any code to work from, normally I can adapt other code with my limited knowledge but in this case I don't know where to start.

Try this:-

Please Login or Register  to view this content.

Regards Mick

Thanks,

This seems to do the trick. I will apply to a much larger sheet and go through some verification but looks very promising.

Thanks again for your help

Thanks,

I'm not sure what is playing up column O.
The great thing this is a code I can apply to different criteria on other spreadsheets should i need to.