Excel validation for a drop down list

Closed
Chandu - Jul 19, 2010 at 10:04 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jul 19, 2010 at 12:18 PM
Hello,

I am trying to achieve this :

I have name range CATEGORY 1
Another name range with CATEGORY 2


I have a cell drop down with CATEGORY1 ,
Now , if i select CATEGORY 1 in another cell, it has to give a drop down list of the CATEGORY2 based on my selection.

Please help me, on how to do this as I am not an expert in excel.

Thank you for your help.




Related:

1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Jul 19, 2010 at 12:18 PM
0