Need to sort by more than 3 columns

The Data/Sort tool only allows a 3-level sort. I need to do an 8-level sort. The best way I can think of to do this is to sort by the first 3 columns, then tell the macro to select only the rows that met all those first three criteria (for example, all Mercury Sables from 2006), then sort that group of cells by the next three columns, and so on.

This is the pseudocode I brainstormed.

select all data
sort first 3 levels
insert column for markers before 3rd-sort-level column
create markers
use markers to select the inclusive rows
sort next 3 deeper levels
insert column for markers before 6th-sort-level column
create markers
use markers to select the inclusive rows
sort final 2 levels

I don't know what VB commands to use to do it. Please help. Thanks!

Hello Bridge_To_Terabithia,

I would use the Auto Filter option under the Data menu. If row is contains the column headers, select the entire row. On the main menu go to Data > Filter > AutoFilter. This will place a drop down arrow in column header. Start with the first column and select the information you want to see. Repeat the process for all 8 columns.

Sincerely,
Leith Ross

Unfortunately, autofilter won't do the job, nor will the pivot-table that came with the data; what I really need is to literally rearrange the order of all the rows, so that the whole list is displayed the way I described.

What I'm really in need of is just some elementary VB commands to:
- execute Data Sort according to known criteria
- recognize when the cell value changes as I go down the column
- set and recognize markers (or variable values) when the change in cell value is sensed
- use the markers to select the specific rows I want to sort next

Any help is much appreciated.