Validation list

[Ulf Nilsson]

Hi,
I have two validation lists.
If I change the first list, I want the second list to adjust to the choice
made.

For example:
If I choose "Fruits" from List 1, I want the result to be in List 2: Apple,
Bananas, Lemon
If I choose "Countries" from List 1, I want the result to be in List 2: USA,
Taiwan, Iraq

I know how to get information from txt-files and how to populate the
validation lists.
I use "Workbook_SheetChange" to look for changes.

How do I find out if it is one of the Validation lists the user is changing?

Please ask more if something is unclear.

// Ulf

 

[Patrick Molloy]

for the first validation list, use the items to range name the other lists

so if your main list is Countries, Fruits
have a table of countries range named countries and a table of fruits range
named fruits

your 2nd validation the LIST and the source is =INDIRECT(A1)
- replace A1by whatever the cell is for the 1st validation cell

example file:
http://cid-b8e56c9a5f311cb7.skydriv...el Files/Data Validation/Data|_Validation.xls

 

[Eduardo]

Hi,
Debra Web has exactly the same example

http://www.contextures.com/xlDataVal02.html