Macro to split Large Worksheet Into Multiple Tabs

Hello to all experts:

I am trying to figure out an advanced way to split data from one tab into multiple tabs based on a certain criteria. I am attaching a sample workbook to this post for reference.

1. The criteria to split to different tabs is in Column E. I would also like the new tab to have the name of the Unique ID in Column E.
2. This list is dynamic so it could have from 5,000 to 30,000 lines.
3. Also, the criteria in Column E may not remain the same month to month. (i.e. some other ID's could be added or taken away from month to month), so I would need a way to pick up new ID's if one exists next time.

I can record the macro using filters, but I would like a shorter, less complicated macro, and I am not that far in my excel knowledge.

Thanks for all your help!

Data.xlsm

Give this a try. It took my comp about 1.5 seconds to work through it all.

Please Login or Register  to view this content.

This works perfectly for me with a little tweaking.

Thanks so much!