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.