need help with conditional data

[Alok]

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.

 

[Ashish Mathur]

Hi,

Please read "Dependent lists" from the following link

http://www.contextures.com/xlDataVal02.html

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com