Data Validation for 3 columns

[nikhil_715]

[TABLE="width: 500, align: center"]
<tbody>[TR]
[TD]TOM
[/TD]
[TD]CANADA
[/TD]
[TD]PANCAKE
[/TD]
[/TR]
[TR]
[TD]MACK
[/TD]
[TD]ENGLAND
[/TD]
[TD]HOTDOG
[/TD]
[/TR]
[TR]
[TD]HARDY
[/TD]
[TD]USA
[/TD]
[TD]BURGER
[/TD]
[/TR]
[TR]
[TD]TOM
[/TD]
[TD]CHINA
[/TD]
[TD]MOMOS
[/TD]
[/TR]
[TR]
[TD]MICK
[/TD]
[TD]CANADA
[/TD]
[TD]PIZZA
[/TD]
[/TR]
</tbody>[/TABLE]
Hi, I have 3 columns , in column A I have around 220 line items which are unique words, in column B there are 433 line items which are unique. All the items in one or the other form in column A are linked to each items in B. (Example I have Tom in column a which has further 2 items which are linked in column B ) and similarly column B is further linked up with column C which has another 1646 line items. I want to validate cells in such a way that when I select from column A drop list , the other cell for column B should only show me the items in the drop list which are related to column A (Ex if I select TOM from the drop list the other list should only allow me to select CANADA ,CHINA in the drop box) further in the third cell it should only allow me to select options which are linked to column B ,in the above case I selected TOM I get to select CANADA OR CHINA then I select CANADA it should allow me to only select from PANCAKE or PIZZA. This is a small example Pancakes might also be linked to another country or name .

The lines are in 1000s so its difficult for me to sort out the list in a new tab like the easy way where you List first column then under each name sorting out the country and then the food.

Thank you in advance

 

[nikhil_715]

Try this example:-
You will need to change sheet2 for your new data , Then close and reopen the workbook.
https://app.box.com/s/9ph1klbnhxhum0gekevmgh1s3pqo4sxs

Super duper cool thankyou so much

 

[MickG]

You're very welcome , Glad its working for you !!

 

[veyselemre]

Example,
https://yadi.sk/i/Wxawc5EBDfif3Q

 

[nikhil_715]

Super duper cool thankyou so much

Hi Need to change or modify the code a bit, there are 2 sheets 1 and 2 ,as you are aware. The data validation is taking place in sheet 1 . I want to add 7 columns in sheet 1 before the data validation. You have created the coding based on the data is in column a b & c. Now since i have inserted columns before them, the columns have moved to h,i,j. In sheet 2 nothing has changed . Now the code is not working. Since I am not a coder i am finding it difficult to make the changes in the code .

Note: the inserted columns don't have any role to play with these 3 data validation columns.
I tried changing the codes but since I am not able to understand the coding language I am messing it up.

 

[nikhil_715]

You're very welcome , Glad its working for you !!

Hi Mick can you help me out with this

 

[MickG]

Try this:-
https://app.box.com/s/6svb35osikyp3kacxwhr5mm7oy1dmjz7

 

[nikhil_715]

Try this:-
https://app.box.com/s/6svb35osikyp3kacxwhr5mm7oy1dmjz7

Thank you

 

[MickG]

You're welcome