Hi all

I have been trying to set up a macro with Sumif & Countifs based on a range of dates.

I have the them working by deleting the rows not needed, however it takes longer than I had hoped due to the deleting of 40k lines.

To counter this i have been trying to set up an auto filter option which does filter, however the dates do not seem to work and the sumif and countifs do not look at the filtered out data.

Anyone have an idea where I am going wrong?

Any help is greatly appriceated.

Thanks

Full code to delete lines

Please Login or Register  to view this content.

Autofilter section
Please Login or Register  to view this content.