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

check out this site it all the instruction for what you are trying
to accomplish I am really a morom and was able to figure it
out usign this site

"Paul" wrote:

I want to have four sets of drop down menus. You would choose Menu 1, and
the options for Menu 2 are based on what you chose for menu 1, and the option
for Menu 3 are based on the choices for Menu 1 and 2, and Menu 4 is based on
the options chosen for Menus 1,2, & 3. I would also like the Menus 2 through
4, to only list uniques names.

There are too many options to create seperate lists and do an Indirect to a
range name.