Check out Debra Dalgliesh's site on dependent data validation lists

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


"Excell" wrote:

Trying to see if anyone has created a macro/form that enables a user to
select an item from a drop down list that will then populate the rest
of the form based on that selection.

Here's an example: Say you're buying a new car and you'd like to be
able to select all of the options associated with a particular model.
If you selected Model A from a drop down list then the rest of the
worksheet would be populated with options relating to that model.
Likewise, if you selected Model B from the drop down list other
information would be populated.

I'm stumped. Any help would be appreciated.