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! |
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! |
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! |
All times are GMT +1. The time now is 11:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com