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.