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...

"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?