Sorting

[dah]

I have a spreadsheet that I sort on several columns. Is there a way t
sort the spreadsheet and then have this sort as a default? I currentl
use comments to tell others what information to sort by but would lik
to do the sort, save the spreadsheet and when another user opens th
spreadsheet, the sort is already the way it should be.

Any thoughts on this?

Thank

 

[Chip Pearson]

I think the closest you could come would be to write a macro to
do the sort in the manner you wish, assign that macro to a
commandbar button, and instruct the users to use your button
rather than Excel's regular Sort commands.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[David McRitchie]

I think I see the sort order become sticky, but I guess you still at
least have to go to the sort.

If the sort is always going to the same for a particular worksheet
you could make that happen on a doubleclick or on a rightclick
macro. That doesn't match your description though.

the following invokes the sort on worksheet activate
http://www.mvps.org/dmcritchie/excel/sorting.htm#activate

More on Event macros
http://www.mvps.org/dmcritchie/excel/event.htm

You would record a macro to get the sort you need.

 

[Dave Peterson]

You may want to add an additional column filled with sequence numbers--added
when the data is in the correct order.

Then you could always just sort by this column whenever you wanted.

(It might even work if the data in those sort columns doesn't change!)