How to create 2 different drop down list based on 1st drop down list

[phantasmyh]

[TABLE="width: 546"]
<colgroup><col span="7"></colgroup><tbody>[TR]
[TD="align: left"]Model [/TD]
[TD="colspan: 3"]spec[/TD]
[TD="colspan: 3"]colour[/TD]
[/TR]
[TR]
[TD="align: left"]model 1[/TD]
[TD="align: left"]a[/TD]
[TD="align: left"]b[/TD]
[TD="align: left"]c[/TD]
[TD="align: left"]white[/TD]
[TD="align: left"]black[/TD]
[TD="align: left"]grey[/TD]
[/TR]
[TR]
[TD="align: left"]model 2[/TD]
[TD="align: left"]a[/TD]
[TD="align: left"]d[/TD]
[TD="align: left"]e[/TD]
[TD="align: left"]green[/TD]
[TD="align: left"]white[/TD]
[TD="align: left"]blue[/TD]
[/TR]
[TR]
[TD="align: left"]model 3[/TD]
[TD="align: left"]c[/TD]
[TD="align: left"]f[/TD]
[TD="align: left"]g[/TD]
[TD="align: left"]yellow[/TD]
[TD="align: left"]red[/TD]
[TD="align: left"]black[/TD]
[/TR]
</tbody>[/TABLE]

Is that anyway to create the 2nd(spec) and 3rd(colour) drop down list base on the selection of 1st drop downlist(Model)?

 

[Rijnsent]

Hi Phantasmyh,
try: https://www.excel-easy.com/examples/dependent-drop-down-lists.html or https://www.contextures.com/xlDataVal02.html
Cheers,
Koen

 

[phantasmyh]

Hi Phantasmyh,
try: https://www.excel-easy.com/examples/dependent-drop-down-lists.html or https://www.contextures.com/xlDataVal02.html
Cheers,
Koen

Thanks, the 1st link contain wht i looking for