• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Help needed on Validation Drop Down

A

ajayxlnc

New Member
Hello Shiva,


I have a data, i mean i have around 11 categories. Each category contains 2 columns, One is Category and the other is the ID. There are around 11 of them like that. I am trying to incorporate a drop down menu for only the categories. When i select the cateogry i want the category and the id to be shown (the entries in the two columns). I tried but not able to do that.

Can you help me out regarding this issue.


Please find the sample data attached


https://docs.google.com/open?id=0B_8nXiEldUKKQUV1aHlWeEtoY2M


ajayxlnc
 
Dear Ajayxlnc,


As per my understanding that, you want a drop down for Categories, if you select category then the related IDs shoudl be displayed. If i am right, then assuem that AAA is category and 1,2,3 are the IDs which are incorporated with AAA Category, if that so then you need dependent drop downs. Please confirm the problem.


Thanks

Vijay
 
Hello Vijay,


Yes, it is right.


For example if we take Category1 table then the items in the table are shown below.


Table-1

--------


Category 1 (Column A)

A

B

C

|

|

U


--


Thread Id (Column B)


xx-123

xx-121

|

|

xx-127


--


-----------


When i click on the drop down menu I want to display only show the Category names like shown below


Category1

Category2

|

|

|

Category11


When i select on Category 1 through the drop down i want data in the table-1 (Shown above) to display. I want the two columns (Category and Thread Id) to be displayed. Same way for all the categories. I want to show only a drop down menu, when i select the category through the drop down i want the data to be displayed.


Is there any work around for this. I am sorry if i am confusing you a bit.
 
Hi ajayxlnc,


I worked out a file could that be of any help to you? Please see:


http://dl.dropbox.com/u/60644346/ajayxlncTest_Solved.xlsx


Regards,

Faseeh
 
Dear Ajay,


Sorry to say this, still i can't understand properly. Please try below link, hope it will solve your problem.

http://www.contextures.com/xlDataVal02.html
 
You must log in or register to reply here.
Back
Top