Hi Everyone,

I have a workbook that has a master data sheet with around 25000 rows of raw data that needs to be filtered on a particular column and then copied into multiple sheets based on the contents of that column, then alphabetises the multiple sheets based on a different column (same column in each sheet) ... I've written code that works (based on what I found from various threads here) but I'm sure there must be an easier way!

It also displays some of the data it's filtering during the running of the macro on the current selected sheet ... weird I would really appreciate some help cleaning it up and making it run faster with no weird stuff going on...

The code below is only the first section showing 2 of 9 repeated sections of code, I thought this might make it easier to understand what I'm trying to do. The 4 digit numbers (7887 and 7757) are 2 examples of the 9 sets I have in my full code. Any help at all would be fantastic!

Cheers,
Jen

Please Login or Register  to view this content.