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

Ananth wrote:

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.

--

Dave Peterson