Improve efficiency of code

I have 4 macros, running one after the other. The main worksheet, Data, contains ~100K lines. Each of the 4 macros filters Data by a string, copies and pastes the results of the filter into another worksheet, then releases the filter on Data. The macros do work as expected, but take ~hour to complete. I'd greatly appreciate any help to speed these macros up.

Here's one of the macros; all are similiar, just work on different strings and paste into a different worksheet -

Please Login or Register  to view this content.

Difficult to comment without a sample of the data to test a solution.

In simple terms, avoid selecting sheets and cells.

It would look something like:

Please Login or Register  to view this content.

I'm a bit concerened about the delete part as, as it stands, it will probably delete the header row too..


Please upload a sample workbook with some typical data and selection criteria if you want to explore this further.

Regards