Help making a route planner

Hello,

Once again I turn to this excellent (pun intended) forum for help. Earlier I made a route planner which sorts based on names of customers.

Now I need it to sort the name (from one cell) and also take the adress from the cell next to it and paste it into a pre-defined route.

I made a small example to further explain.

I've been bangin' my head on this one, so please help. :-)

Thanks!

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

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.

in the example data you provided, why wasn't Customer 7 assigned to Route #1 ? Are routes limited to 2 deliveries per day ?

Originally Posted by ThirtyTwo

in the example data you provided, why wasn't Customer 7 assigned to Route #1 ? Are routes limited to 2 deliveries per day ?

I just tried to make an example which made the info pop up about "NOT IN ROUTE"

1. Customer 7 is a new delivery this week (not been driven ever beforee)
2. It's actually not in the master list for route #1 but it should be placed there

I just need a small mechanism to notify my if there's any new customers not yet in any routes which needs to be added to a route. I see now that I should have made the example clearer. :-)

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.