Picture this, boss strolls in and asks to have a report ordered in a different way. Fine I thought easy, but he wants the report orded in the way the drivers are to do their pickups.

Now a new list is easy give each location a number sort on the number, fine.

Now the problem, how to insert new locations and keep the list in route order?

I presume it will have to involve vb in some way

Thanks for any advice, feel free to ask for any clarifications