Is there a way to Auto sort or save a sort?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
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.
 
record a macro and run it each time.

Dorlynne said:
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.


:
Click to expand...
 
Not that I know.

If I had to do it, I'd record a macro when I did it manually. Then I'd store
that macro in a different workbook (not the .rtf) and just open that workbook
with the macro whenever I needed to sort the data.
 
I am too in need of some automatic formula to not only auto sort every time I
add a row to the spreadsheet or update my indicator but also to do a subsort
within the indicator sections by date that is indicated in a specific column.
I don't mind doing a repeat each day but I have to do the first sort then
select the sub section, each one I need sorted and redo for the date because
it won't conserve the rows...anyway to avoid this?
 
We're looking for a way to keep the sort settings. We add a few lines each
day & now when we go to Data > Sort, we have to check "no header row" &
choose columns again. In previous worksheets, it seemed to keep the
settings. We use Excel 2003.

Thanks!
Kristi
 
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.
 
Can't create new macros? Perhaps you in Compatibility mode? Save as
macro enabled workbook.
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.

:
Click to expand...
 
Kristi Chadwell said:
We're looking for a way to keep the sort settings. We add a few lines each
day & now when we go to Data > Sort, we have to check "no header row" &
choose columns again. In previous worksheets, it seemed to keep the
settings. We use Excel 2003.

Thanks!
Kristi
Click to expand...
 
So far, my impression of Office 2007 and it's "New" threads is that is really
"sucks". The idea that we would have to write a MACRO to do something that
an earlier version did automatically is ludacrous. I've been doing this for
25 years and early on programs gave you the option to set program
preferences. Dave Peterson talks about not wanting things too automatic.
That's fine but I sure as @#$@ don't want to have to do everything manually.
Good grief!!!!!
 
It doesn't automatically sort every time you put in data, but if you use a
custom sort then save the workbook, the custom sort is saed with the
worksheet that it is associated with. I have a spreadsheets that have a few
columns that need to be resorted, then used to update the other columns on
the spreadsheet. In all three cases, I created a named range "sort" that
includes plenty of space for expansion and use my saved custom sort after
selecting htis range. I then do one of the following:

1. Nothing, it works fine for that spreadsheet because my named range
excludes the other columns and there is little danger to danga, formulas,
etc. involved.

2. I keep the "working data" on a separate sheet and manually copy those
columns into the "real" one after I update and sort the data on the "working
data" worksheet.

3. I have a "working data" worksheet where I add, delete, edit, and sort
the data. On the "real" worksheet, the there are formulas in the colums that
pull in the data from the "working data" worksheet. For example, in cell A1
is ='Working Data'!A1, in A2 is ='Working Data'!A1 and so on...
 
Back
Top