You can find some info here about dependent drop down lists, and use that as
a starting place. Make the first list your 10 hi-level categories &
subsequent lists will depend on the first choice made

http://www.contextures.com/xlDataVal02.html


"Simon" wrote:

I have a spreadsheet around 6000 rows long. I want to include a means of
navigating around the spreadsheet in a freeze framed section at the top. I
have considered a number of options including a simple drop down list (via
the validaton command) and a goto button in VBA or the use of a dropdown list
and hyperlinks.

While this works reasonably well there are arond 100 locations I wish to
navigate to and including these in a single drop-down list is not practical -
I really want to be able to have some sort of drop down list which displays
10 high level categories, then within each of these categories a further 10
sub categories, much like standard office menus. Does anyone have any useful
pointers or VBA to help me achieve this

cheers

Simon