Excel - Sort

R

rekoop

Hello,

I have a four level sort that I use quite often. It is
possible to "save" my sort parameters/order so I do not
have to set it up each time?

All suggestions are appreciated.
 
P

Paulw2k

Use a macro to sort. You can record most of the recording with a practice
run, then twig it appropriately
 
D

DDM

Rekoop, one way to approach this is to use a "helper" column. Say you
regularly sort on Columns D-A. In a helper column right next to the data,
enter a formula that combines the values from these columns: =D2&C2&B2&A2
(assuming you have column labels in Row 1). Copy the formula down for as
many rows as you have data. Hide the column, then use it to sort on.
 
Top