Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a way to Auto sort or save a sort? | Excel Discussion (Misc queries) | |||
Auto sort | Excel Worksheet Functions | |||
Auto-Sort Won't Sort All Column Cells | Excel Discussion (Misc queries) | |||
Auto Sort ??? | Excel Discussion (Misc queries) | |||
auto sort? | Excel Discussion (Misc queries) |