You can use Data Validation with dependent lists.

See Debra Dalgleish's site for method.

http://www.contextures.on.ca/xlDataVal02.html


Gord Dibben Excel MVP

On Tue, 12 Apr 2005 09:51:04 -0700, Rob wrote:

I'm trying to set up a drop down list that once a major chategory is
selected, another drop down list is displayed with more detailed information.

This is similar to the normal menus we see, i.e. clicking on "file" and then
"new" displays another drop down menu with "Window Ctrl+N" and other options

Thanks.