See this:

http://contextures.com/xlDataVal02.html

Biff

"govols865" wrote in message
...
Hi! Can anyone help me?

I have Excel 2003.

I have created several validated lists. Now, I want to be able to tie
these
together.

For example, in the first cell, my drop down list choices are A, B, and C.
I
would like the second cell to bring up a drop down from a validated list
that
I have created, and the list that is shown is dependent on the original
choices in my first cell (A,B, or C).

So for example, if in my first cell I chose 'Car Manufacturer' from my
validated drop down list, I want the second cell to show drop down choices
from the list I created that includes Acura, Ford, etc. BUT, if I choose
'Motorcycle Manufacturer' in my first cell, I want the second cell to show
choices from another list (Honda, Kawasaki), etc.

Does this make sense? How can I do this?
Thank you for your help!
Angie