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