Variable Validation List

[Ananth]

Variable Validation List

I have huge database pulled from Hyperion showing County/Country/Continent
Field Sales Performance data

Roughly the database has 100 Columns and 25000 Rows.

I have created 3 Validation lists

1 County List
2 Country List
3 Continent List

I have created a common Report that pulls up important parameters .

I want my company president simply to choose a Option

1) Which list he wants to review ( 1 or 2 or 3) ( in Cell A2)
2) Based on the input in Cell A2, I want the Validation list in B2 to Change
to County /Country /Continent.

Is it feasible or I am asking too much from EXCEL.

 

[Kassie]

In A2, create a Data Validation cell, with list values of Continent, Country
and County.
In B2, create a data validation cell that gets values from a list. In the
refers to box, enter =INDIRECT($A$2)
So, if he select Continent, then in B2 he will have a list of continents;
If he selects Country, then in B2 he will have a list of countries.
If he Selects County, then in B2 he will have a list of counties.
You can also use 3 iso 2 cells. Then, in the first, he can select the
continent he wants to work with, in the second one he can select the country
on that continent he wants, and in the third one the county. Do this by
creating the various lists, and then in the validation refers to boxes, using
=INDIRECT($A$2), =INDIRECT($B$2) and =INDIRECT($C$2)

--
HTH

Kassie

Replace xxx with hotmail

 

[Dave Peterson]

Debra Dalgleish shows how to use dependent lists with data|validation here:
http://contextures.com/xlDataVal02.html