Sorting A large list into smaller lists on different sheets

[mkeohan]

Hello Everyone,

I currently get a list of addresses from a lead generation company daily. I want to be able to take that list and segment it into smaller lists by zip codes that are in each of my companies territories. This way I can make Mail Merge documents from the smaller lists so they correspond with the correct office. The way I have it set up currently is the main data set is on the first sheet marked Full List. The second sheet is the first list but with customers with fuel type Gas removed. The third sheet is a break down of the territories for each office with both the town name and zip code. The other sheets are where I want the matched entries to go from the second sheet so I can make the Mail Merge Documents. If you have any questions please let me know and I will do my best to clarify. Thank you in advance I've been banging my head against this problem for two days and I'm no closer to a solution.

In the dropbox link down below I have the file.


https://www.dropbox.com/s/nuqscmvu1fvdla6/Zip Leads Back Up System.xlsx?dl=0

 

[Fluff]

@Roger Govier
One of the things about Excel is there are so many of doing something.
Thanks to you the OP now has 2 options & can choose which they prefer.