Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
select list by selecting a cell
I have created four lists. List A is the main type list and List B, C and D
are the sub-types. Is it possible that by selecting a value in List A in a cell, I can call List B, C or D in another cell. Please help... |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
select list by selecting a cell
i!
Are you talking about data validation drop down lists? If so, yes, you can do this. Need more detail for a better solution but in general this is how you would do it: The main list would contain the names of all the other lists. The selection made from that list would dictate which sublist is displayed in the other cell. See this: http://contextures.com/xlDataVal02.html Biff "Dire straits" <Dire wrote in message ... I have created four lists. List A is the main type list and List B, C and D are the sub-types. Is it possible that by selecting a value in List A in a cell, I can call List B, C or D in another cell. Please help... |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
select list by selecting a cell
Biff,
Thankyou. With the information that you provided made me complete the task and create the "dependant lists". Thank you very much. "Biff" wrote: i! Are you talking about data validation drop down lists? If so, yes, you can do this. Need more detail for a better solution but in general this is how you would do it: The main list would contain the names of all the other lists. The selection made from that list would dictate which sublist is displayed in the other cell. See this: http://contextures.com/xlDataVal02.html Biff "Dire straits" <Dire wrote in message ... I have created four lists. List A is the main type list and List B, C and D are the sub-types. Is it possible that by selecting a value in List A in a cell, I can call List B, C or D in another cell. Please help... |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
select list by selecting a cell
PS: I rate the reply five stars *****.
"Biff" wrote: i! Are you talking about data validation drop down lists? If so, yes, you can do this. Need more detail for a better solution but in general this is how you would do it: The main list would contain the names of all the other lists. The selection made from that list would dictate which sublist is displayed in the other cell. See this: http://contextures.com/xlDataVal02.html Biff "Dire straits" <Dire wrote in message ... I have created four lists. List A is the main type list and List B, C and D are the sub-types. Is it possible that by selecting a value in List A in a cell, I can call List B, C or D in another cell. Please help... |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
select list by selecting a cell
You're welcome. Thanks for the feedback! And thanks to Debra Dalgleish for
having a great site!! Biff "Dire straits" wrote in message ... Biff, Thankyou. With the information that you provided made me complete the task and create the "dependant lists". Thank you very much. "Biff" wrote: i! Are you talking about data validation drop down lists? If so, yes, you can do this. Need more detail for a better solution but in general this is how you would do it: The main list would contain the names of all the other lists. The selection made from that list would dictate which sublist is displayed in the other cell. See this: http://contextures.com/xlDataVal02.html Biff "Dire straits" <Dire wrote in message ... I have created four lists. List A is the main type list and List B, C and D are the sub-types. Is it possible that by selecting a value in List A in a cell, I can call List B, C or D in another cell. Please help... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
selecting next available cell | Excel Discussion (Misc queries) | |||
How to dynamically select a validation list from data in a cell? | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
changing value of a cell by selecting an item from a drop down list | Excel Worksheet Functions | |||
How select an item in a list box | Excel Worksheet Functions |