Multi-Column Sort (Using more than 3 Columns)
Posted by Neil Roberts on August 21, 2001 3:22 AM
My problem is that I have a data set with more than 3 key columns that I want to sort by, and Excels sort only allows 3. Whatever the solution is, I need to be able to access it via VBA as a macro runs at the end of the data extraction process, and the sort is the last part.
If it was just for my use I would do it manually, selecting three columns at a time and the relevant row groupings; but various other people that I think would find it useful use the data set as well.
If anybody can help it would be great and much appreciated.