Large Excel Document - remove entries (multiple)

Hi there,

I have a large excel file (it will have tens of thousands of entries in) and I would like to filter and delete out rows that are not needed (because the file is so large copying it makes the computer hang!).

I would like help in identifying the best way to use VBA to remove rows based on a criteria - but I am not sure the criteria is the easy to do.

I would like to remove any row where Email 1 equals Email 2 BUT the date in (Week Ending) must also be in the last 15 days.

On top of this I would like to remove any row where the value in column B is Xe. I would also like to remove any row where the value in column Q is Service 44!

Any help is greatly appreciated - my example workbook is attached.

Regards,

GISVPN
Example-Book-1.xlsx