Help making a route planner

Originally Posted by Xx7

Here's a pivot table that does it on Sheet1.

If I'm not mistaken this does not make it automatically? I still need to enter Y/N in the "Include" column manually?

The thing I didn't say was that every customer does not got a delivery every day. The list changes randomly. For example Customer 1 only needs delivery monday, wednesday and sunday one week, and something else the next week.
Also it will not necessarily come a list to me sorted like "Customer 1" thru "Customer 10". It can be sorted in any variety of different of ways (start with Customer 7, and Customer 1 can be listed as number 3 etc).

What I need is for the routes to be "filled in" automatically.

Originally Posted by tk240381

If I'm not mistaken this does not make it automatically? I still need to enter Y/N in the "Include" column manually?

The thing I didn't say was that every customer does not got a delivery every day. The list changes randomly. For example Customer 1 only needs delivery monday, wednesday and sunday one week, and something else the next week.
Also it will not necessarily come a list to me sorted like "Customer 1" thru "Customer 10". It can be sorted in any variety of different of ways (start with Customer 7, and Customer 1 can be listed as number 3 etc).

What I need is for the routes to be "filled in" automatically.

1) Please confirm that the only data being changed is in "BLUE" on Sheet1
2) The attached will update the pivot table (Column H-K) automatically whenever any data is changed.
3) If you enter anything in the "Description" field (Column C), the record will be removed from the pivot table.

Originally Posted by Xx7

1) Please confirm that the only data being changed is in "BLUE" on Sheet1
2) The attached will update the pivot table (Column H-K) automatically whenever any data is changed.
3) If you enter anything in the "Description" field (Column C), the record will be removed from the pivot table.

1. Data in blue is the only thing beeing changed except column C.
Column C is a column which only informs the user that this customer is not set in any of the routes, and need to be assigned a route number and where in the order it is supposed to be dlivered.

So it needs to do to things. What is written in column A + B will be assigned to a route and also put in the correct order.
Column C will notify me if the customer is not assigned a route.