Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
create 3 drop down menus in Excel, each relating to previous
I need to create 3 different drop menus, each has to relate the previous data:
Eg., column A has 4 pieces of data, column B has 16 pieces of data, but only certain data refers back to one of the data elements in the column A. So if I choose the 1st data element in Colum. A, rather than all 16 data elements in Colum. B showing, it should only show what directly corresponds to the 1st data element in Colum. A. Thanks for any help... |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
create 3 drop down menus in Excel, each relating to previous
Take a look at:
http://www.contextures.com/xlDataVal02.html HTH "ExcelDropDownQ" wrote: I need to create 3 different drop menus, each has to relate the previous data: Eg., column A has 4 pieces of data, column B has 16 pieces of data, but only certain data refers back to one of the data elements in the column A. So if I choose the 1st data element in Colum. A, rather than all 16 data elements in Colum. B showing, it should only show what directly corresponds to the 1st data element in Colum. A. Thanks for any help... |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
create 3 drop down menus in Excel, each relating to previous
I have done this in the past, though I'm interested in seeing others
approaches.... I created "tables" using Insert/Name/Define for each of the lists and the name asssigned to each table had a name in it from the previoius column. In my case, Column A contained Organization names (there were 8 possible) so I have a table Table_Organizations (for illustration assume Org1, Org2, Org3,....Org8) which defined all 8. I then create a Tables witht the list of employees in each organziation and defined its range via a Insert/Name/Define and named it Table_Org1_Employees. With the above in place, I then set up the data for validation for the drop down for employees to key off of what specified in the column for the organization. The equation I used in the Data Validation was: =INDIRECT(CONCATENATE("Table_",INDIRECT(CONCATENAT E("$a$",ROW())),"_Employees")) Sorry for the limited details - time is the issue - hope this is sufficient to get you going in the right direction. "ExcelDropDownQ" wrote in message ... I need to create 3 different drop menus, each has to relate the previous data: Eg., column A has 4 pieces of data, column B has 16 pieces of data, but only certain data refers back to one of the data elements in the column A. So if I choose the 1st data element in Colum. A, rather than all 16 data elements in Colum. B showing, it should only show what directly corresponds to the 1st data element in Colum. A. Thanks for any help... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
formulas for drop down menus | Excel Discussion (Misc queries) | |||
how do i set up drop down menus to populate cells in excel? | Excel Discussion (Misc queries) | |||
How do you create a calendar drop down in excel? | Excel Discussion (Misc queries) | |||
How do I create a drop down list in Excel 2003 | Excel Discussion (Misc queries) |