I have tried this several times in Excel 2007 and it does not retain the sort
criteria. The macro method is how I did it with Excel 2003. Surprisingly,
the sort macros I used from 2003 still actually work. However, I can't
create new ones. Microsoft needs to create a "Save Sort" function.

"Bob I" wrote:

record a macro and run it each time.

Dorlynne Harris wrote:

Is there a way to create a spreadsheet that retains the default sort order
for Xl2007? I have to recreate the same sort everyday for a spreadsheet and
the information is almost identical on a day to day basis. I receive an
email in .rtf and then copy and paste to XL and then sort. The information
changes slightly from day to day and it is tiresome having to recreate every
sort and it is only 3 columns that are being sorted.


"Dave Peterson" wrote:


Personally, I don't like things too automatic. I'm afraid that if I enter
incorrect data, it could sort to whoknowswhere and it would take forever to find
and correct it.

But I don't like doing the same thing over and over again, either.

In xl2003, you can apply data|filter|autofilter to the range and use the
dropdown arrow to sort your data.

Debra Dalgleish has a technique at her site that adds invisible rectangles in
the headers and then sorts the data by that field when you click on one of those
rectangles.

http://contextures.com/xlSort02.html

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Barbie wrote:

Is there a way to create a spreadsheet that retains the default sort order,
so that new information added to the bottom of the spreadsheet will
automatically be moved into the proper position within the saved sort?

--

Dave Peterson