Can Excel sorts be saved and used again?
- by Robert Kerr
On an Excel 2007 worksheet, I have several tables, each sharing the same columns. For every table, I sort in several particular ways, depending on the task at hand. It gets tedious going to the Data tab, clicking Sort, unchecking the "my data has headers" checkbox, then add/removing the columns and ordering sort criteria.
Is it possible to:
* Save a given sort criteria (a named sort)?
* Apply the sort against any selected range?
* Create a button to execute each saved sort?
In the end, I would create 4 or 5 named sorts and a button for each on the worksheet. Then would be able to select any range of rows, from any table, and click one of the sort buttons. The sort would execute.
