ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I save my 'sort criteria' in an Excel file? (https://www.excelbanter.com/excel-worksheet-functions/56190-how-do-i-save-my-sort-criteria-excel-file.html)

Jobod

How do I save my 'sort criteria' in an Excel file?
 
Having established a sort order over 3 columns in a file, I find that it
works quite well with no problems. When I return to that file after
inserting new data, and wish to re-sort to the previous established sort
order, I find that I have to go through the 3 columns again to set my order.
There does not appear to be any way to save that sort order for that
particular file.
I am using Microsoft Excel 2000 v 9.0.6926 SP3


Lotus123

How do I save my 'sort criteria' in an Excel file?
 

As long as the sort range has not changed dramatically, Excel should
remember the previous sort used.

Option 1: Instead of using a specific range (A1:C100) you might try
sorting the entire columns (A:C). All of the blank items should go to
the bottom..and as long as you don't have totals, it should work the
same without any extra tweaking.

Option 2: Create a macro to do the specific kind of sort you want.
Then just run your macro every time (I've used that for some sorts I do
just so that I don't have to click "Data-Sort-OK" all of the time).


--
Lotus123
------------------------------------------------------------------------
Lotus123's Profile: http://www.excelforum.com/member.php...o&userid=28611
View this thread: http://www.excelforum.com/showthread...hreadid=486243


PATRICK AND CHERY LANANE

How do I save my 'sort criteria' in an Excel file?
 
Could U set up a custom view for the data that you to retrieve?
I have used that for same criteria data that was repetitious, I customized
various views pulling the fields of info I needed for a particular report.
It was a 'quick fix' for what I needed and not enough time/experience to
figure it all out..

"Jobod" wrote in message
...
Having established a sort order over 3 columns in a file, I find that it
works quite well with no problems. When I return to that file after
inserting new data, and wish to re-sort to the previous established sort
order, I find that I have to go through the 3 columns again to set my

order.
There does not appear to be any way to save that sort order for that
particular file.
I am using Microsoft Excel 2000 v 9.0.6926 SP3





All times are GMT +1. The time now is 07:11 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com