"I have a distribution list of 5 cities in cell A1, 5 manufacturers in cell
B1, 5 products category in cell C1, and 5 product list in cell D1."

Now, I want that if I select one particular city in cell A1, then it should
give me options to select manufacturers available in that city only.

Again, when I select one particular manufacturer in cell B1, then in cell C1
it just show me product category produced by that particular manufacturer.

Then, continuing from previous step I select one product category from that
list (cell C1) and then it should give me products list under that category
in Cell D1.

Now, finally selecting an item from the product list in Cell D1, it should
pop up the username in Cell E1.

Now, as far as this username is concerned I know their combination......

So, what I want is that.... when particular city, manufacturer, category and
product is selected it gives me username in cell E1.

I think you might do better using either ComboBox or ListBox controls, or a
combination thereof. As I understand your posting, you are trying to use
dropdown lists, e.g. comment boxes, tied to specific cells. Trying to get
selective portions of those lists to display can be problematic, if not
impossible.



"mahendra2210" wrote in message
...
"I have a distribution list of 5 cities in cell A1, 5 manufacturers in
cell
B1, 5 products category in cell C1, and 5 product list in cell D1."

Now, I want that if I select one particular city in cell A1, then it
should
give me options to select manufacturers available in that city only.

Again, when I select one particular manufacturer in cell B1, then in cell
C1
it just show me product category produced by that particular manufacturer.

Then, continuing from previous step I select one product category from
that
list (cell C1) and then it should give me products list under that
category
in Cell D1.

Now, finally selecting an item from the product list in Cell D1, it should
pop up the username in Cell E1.

Now, as far as this username is concerned I know their combination......

So, what I want is that.... when particular city, manufacturer, category
and
product is selected it gives me username in cell E1.

check debra's site
http://www.contextures.on.ca/xlDataVal02.html
--


Gary Keramidas
Excel 2003


"mahendra2210" wrote in message
...
"I have a distribution list of 5 cities in cell A1, 5 manufacturers in cell
B1, 5 products category in cell C1, and 5 product list in cell D1."

Now, I want that if I select one particular city in cell A1, then it should
give me options to select manufacturers available in that city only.

Again, when I select one particular manufacturer in cell B1, then in cell C1
it just show me product category produced by that particular manufacturer.

Then, continuing from previous step I select one product category from that
list (cell C1) and then it should give me products list under that category
in Cell D1.

Now, finally selecting an item from the product list in Cell D1, it should
pop up the username in Cell E1.

Now, as far as this username is concerned I know their combination......

So, what I want is that.... when particular city, manufacturer, category and
product is selected it gives me username in cell E1.