Thread: Dropdown Lists
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Dropdown Lists

See this:

http://contextures.com/xlDataVal02.html

--
Biff
Microsoft Excel MVP


"Trouble" wrote in message
...
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