View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Akash Maheshwari Akash Maheshwari is offline
external usenet poster
 
Posts: 31
Default Query of List Option

Hi,

Need your help,

I have two sheets named as Workings & Database

In the sheet named as Database, i have two columns

Product : Vendor

The Product can be same but Vendor can be different.

In the sheet named as Workings, I would use List Option to select
Select Product. As soon as I select any Specific Product the second
list should show me only those list of vendors who deals into the
specific product.

Pls help me how to populate this in MS Excel.

Rgds

Akash Maheshwari