Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Variable Validation List
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Variable Validation List
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 "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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Variable Validation List
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
variable in data validation | Excel Worksheet Functions | |||
Help for multiple & variable validation function | Excel Worksheet Functions | |||
data validation: variable drop down | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions |