I read someone else's Q&A who needed to sort 9 columns (If you mean you want
to have 9 levels of sort, then since xl only allows 3
fields per data|sort, you can sort by the 3 most minor, then sort by the 3
middle, then sort by the 3 major fields.That'll be 3 different data|sorts.)
I only need to sort 4 columns, but I don't understand what it meant by
sorting from minor to major. In my case, I need data to be in Location A,
Location A Sub level, Work Order, and Activity. Does it mean I should sort
in reverse order from Activity. What do you do after you do the first 3 sort
available in xl, sort order will reshuffle when I start the sort option box
for my last sort. Please help. Thanks.