sorting
 

is there a way to sort an excel sheet if there using
about 10 columns to sort by? if i go to data sort the
max i can sort by is 4.

I bet that you meant 3 was the maximum.

But that's a maximum number of keys per sort.

If you want to sort by 10 keys, do a sort using keys 10-9-8, then another 7-6-5,
then 4-3-2, then just the primary key (1).

If I had to do this lots of times, I'd record a macro when I did all 4 sorts,
then just rerun that macro when required. (A nice button from the Forms toolbar
assigned to that macro would be pretty useful, huh?)

frank wrote:

is there a way to sort an excel sheet if there using
about 10 columns to sort by? if i go to data sort the
max i can sort by is 4.

--

Dave Peterson