Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I relate three or more lists to one another?
How can I relate three or more lists to one another? For example:
If someone choses a manufactuer, then the next list will list only models by that manufacturer. Then, if they choose a certain model, only the colors available in the model by the manufacturer will appear on the third list. So on and so forth. Any help or comments would be greatly appreciated! |
#2
|
|||
|
|||
Matt
Why not use one complete list and use Auto Filters (or advanced filters) to show just the results you want? regards Peter "Matt" wrote: How can I relate three or more lists to one another? For example: If someone choses a manufactuer, then the next list will list only models by that manufacturer. Then, if they choose a certain model, only the colors available in the model by the manufacturer will appear on the third list. So on and so forth. Any help or comments would be greatly appreciated! |
#3
|
|||
|
|||
Matt
You could use Data Validation drop-down dependent lists. For setup of this see Debra Dalgleish's site. http://www.contextures.on.ca/xlDataVal02.html You can create several "and so forth" lists dependent upon the choice in the drop-downs. Gord Dibben Excel MVP On Mon, 22 Nov 2004 12:41:02 -0800, "Matt" wrote: How can I relate three or more lists to one another? For example: If someone choses a manufactuer, then the next list will list only models by that manufacturer. Then, if they choose a certain model, only the colors available in the model by the manufacturer will appear on the third list. So on and so forth. Any help or comments would be greatly appreciated! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I compare two lists of names in excel? | Excel Discussion (Misc queries) | |||
Data Validation Lists | Links and Linking in Excel | |||
Aligning Two Lists in Excel | Excel Discussion (Misc queries) | |||
finding common numbers in large lists | Excel Worksheet Functions | |||
Sort 2 lists - one w/ last, first name // one w/ first, last name | Excel Worksheet Functions |