Spitting every 2000 rows of data to new workbook based on duplicate value

[navyret2009]

To All;
Hi everyone its been a while since I have posted a question here and hoping you can help me.

Every 6 months I recieve a workbook from a vendor that contains various numbers of rows and in this workbook there are duplicate values in column "e" called "Dupe Group". Now these duplicate values will vary in count 2, 4, etc.

What I need to do is create a means to sort the data on column E, copy every 2000 rows of data (may vary on where duplicates end) and put into new tab.

 

[Skyybot]

Can you share the above Sheet (not Tab) via XL2BB instead of picture? I would like to help but I'm not typing 2000 rows of data to test with. Also, what version of Excel are you using? That information is not in your User Profile.