I have cracked it with the simplest solution ever!

I have the first column (Sector) as a normal list with a load of sectors in
it.

I then have a separate sheet with the sub-sectors in and each is named with
the corresponding name identical to the Sector list above.

In the Select Sub Sector column I then have a very simple thing in the list
source area stating =INDIRECT(<Cell) and this means it takes the value in
the previous one, which corresponds to a name, and pulls the list over.

Job done.!

--
Message posted via http://www.officekb.com