Can an Excel Spreadsheet automatically sort new data?
 

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?

Can an Excel Spreadsheet automatically sort new data?
 

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

Can an Excel Spreadsheet automatically sort new data?
 

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