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!