Auto sort
 

I want to take a list of customers and sort them by 'date of next visit'
(closest date being at the top of the page). After each visit, I would
assign a new date (for next visit) and the sheet would update itself
automatically, so each day I just have a list of customer at teh top of my
page that I have to go and see.

It would also be nice if I could put them in the order that they are to be
visited in, but I have a feeling that I will be relying on MS's Streets and
Trips to accomplish this (any way to have these two things communicate with
one another automatically?)

Your help and advice is greatly appreciated.

Andrew

Auto sort
 

How about an alternative?

Debra Dalgliesh has some code that allows you to click an invisible rectangle
floating over that column's header to sort by that column.

http://contextures.com/xlSort02.html

A wrote:

I want to take a list of customers and sort them by 'date of next visit'
(closest date being at the top of the page). After each visit, I would
assign a new date (for next visit) and the sheet would update itself
automatically, so each day I just have a list of customer at teh top of my
page that I have to go and see.

It would also be nice if I could put them in the order that they are to be
visited in, but I have a feeling that I will be relying on MS's Streets and
Trips to accomplish this (any way to have these two things communicate with
one another automatically?)

Your help and advice is greatly appreciated.

Andrew

--

Dave Peterson