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?

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

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