Dropdown Lists

[Trouble]

Dear Excel experts,

I have a very basic question, I have an existing invoiceTemplate and I
have created 3 separate lists:

DVDs
Books
Others

In the Item column I would like to pull the data from these 3 lists:

Here is it what I want to to:

First of Select whether it's Book, DVD or other
Then go to the Item column and select the Item
if I have selected the DVD then it should Hide books and other item
and vice versa

Looking for advice

I am new to excel.

Many thanks for your help.

Saqi

 

[T. Valko]

See this:

http://contextures.com/xlDataVal02.html

 

[FSt1]

hi
sounds like you are talking about cascading combos or dependent combos.
assuming your are useing data validation here so see this site....
http://www.contextures.com/xlDataVal02.html

regards
FSt1