Can an Excel Spreadsheet automatically sort new data?

[Stumped]

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]

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]

Thanks Dave. I'll check on this.

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