Thanks Dave. I'll check on this.

"Dave Peterson" wrote:


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

Stumped wrote:

I have set up a simple worksheet as a shipping log. Date, sent to, mode,
tracking and a refernce column. I currently sort by columns A (date)
descening and B (last name) ascending.
When I enter a new line of shipping information, or several, is there a way
that the spreadsheet will automatically sort the data into the correct order?

--

Dave Peterson