Layered lists

[David]

I am trying to creat a data entry form where users make a selection from list A, then based on this entry, list B provides a list of options, then List C is provided on the previous entries.


I have tried with data validation, however, I want a data input form to record the entries and other comments then store them on another sheet.


ie...

I make a selection from 1-5, then if I select 3, List B will have 5 options (which are distinct to selection 3. If i select 2, (3 then 2) then List C will have an indepentant list also.


Suggestions would be greatly appreciated.


Thanx

David

 

[prazad82]

Hello David,


Could you please upload a sample? So that i can explain better

 

[Debraj]

Hi David,


First of all... Try to search "Dependent Validation" at the top Google Search Bar in this page.. Then.. Click any of the link.. and try to adapt the same according to your data..


If you unable to adapt it then.. read the below file..

https://dl.dropbox.com/u/34893656/Data%20Validation.docx

(if someone claim that this file is mine.. then.. ask him to solve your problem..)


else.. We are here to walk with you..


Regards,

Deb

 

[David]

list 1:

1,2,3,4,5

If 1 selected then list 2 becomes:

1a, 1b, 1c, 1d,

if 2 selected then list 2 becomes:

2e, 2f, 2g, 2h, 2i etc...


the drop down box cited above is in the sheet itself. I am looking for a "Click Here" button to open a form that will have the control box selections. the 2nd contolbox selection list is dependant on the selection from controlbox1. Controlbox2 will be dependant on the selection from controlbox2.


Thanx very much for your insights...

David

 

[NARAYANK991]

Hi David ,


The example posted is slightly confusing ; when 1 is selected from the first list , the second list has 4 items , but when 2 is selected from the first list , the second list is shown having 5 items ; is this correct ?


Secondly , are the lists really having 1 , 2 , "a" , "b" ,... or do the lists have data which you can post here ? If so , are there ranges for these lists ?


Can you check out these links ?


http://www.myonlinetraininghub.com/excel-factor-19-dynamic-dependent-data-validation


http://www.davesexcel.com/dependentcombobox.htm


Narayan

 

[David]

Thanx very much.

lets say list one is a grocery list..

cheeze, meat, juice, vegies...

when i select meat, list 2 would be a selection of available meats... if i choose juice, a list of available juices would be available.... now if i choose juice, then one of the juices is apple, then list 3 could be brands. (juice - apple - McIntosh)

I think it can be done with the dependent combobox, but i want it in a userform for data entry.


I appreciate your thoughts and suggestions.


David