Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need help with conditional data
I have two worksheets. Worksheet A has item names and company names. Item
names are unique, but not company names. In worksheet B, I want to select a company name first, and then display the item names in drop down list in next column, which belong to that company name only. Please help me out. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need help with conditional data
Hi,
Please read "Dependent lists" from the following link http://www.contextures.com/xlDataVal02.html -- Regards, Ashsih Mathur Microsoft Excel MVP www.ashishmathur.com "Alok" wrote in message ... I have two worksheets. Worksheet A has item names and company names. Item names are unique, but not company names. In worksheet B, I want to select a company name first, and then display the item names in drop down list in next column, which belong to that company name only. Please help me out. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Data Validation | Excel Discussion (Misc queries) | |||
Conditional Data Validation | Excel Discussion (Misc queries) | |||
Conditional data | Excel Worksheet Functions | |||
conditional data validation | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |