Every day I get a list from my customer with 100-150 customers on 6-8 different routes I need to deliver.

For now I manually sort them via cut & paste, and an hours work to do so.

Is there any way to make life easier for me? I've made an example file with how I get the route from my customer, and how it looks after I sort it.

I'm thinking, if I maybe make a "master" list with the correct order to drive in, and make some formula to sort it?

Thanks!

File attachment: Sorting_problem.xlsx