Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dropdown Lists
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dropdown Lists
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 "Trouble" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dropdown lists | Excel Discussion (Misc queries) | |||
dropdown lists | Excel Worksheet Functions | |||
Dropdown Lists | Excel Discussion (Misc queries) | |||
Dropdown Lists... | Excel Discussion (Misc queries) | |||
Dropdown lists | Excel Discussion (Misc queries) |