I have a table (Table1) containing CATEGORY,OPTIONS,COMMENT e.g.
CatA, Option1,Comment1
CatA, Option2,Comment3
CatA, Option2,Comment3
CatB, Option1,Comment1
CatB, Option2,Comment2
CatB, Option3,Comment3
I'll break down the scenario I'm trying to create...
1. On a separate sheet I want to have dropdown lists in A1, A2, A3 etc which list all the entries in the OPTIONS column based on a category e.g.A1 to A3 shows CatA options, A4 to A6 show CatB options etc.
2. I then want any selected option to not appear in the subsequent dropdowns and to reappear if not selected.
3. Then whatever is in the COMMENT column to appear in column B bassed on the selection in column A.
I hope that makes sense
CatA, Option1,Comment1
CatA, Option2,Comment3
CatA, Option2,Comment3
CatB, Option1,Comment1
CatB, Option2,Comment2
CatB, Option3,Comment3
I'll break down the scenario I'm trying to create...
1. On a separate sheet I want to have dropdown lists in A1, A2, A3 etc which list all the entries in the OPTIONS column based on a category e.g.A1 to A3 shows CatA options, A4 to A6 show CatB options etc.
2. I then want any selected option to not appear in the subsequent dropdowns and to reappear if not selected.
3. Then whatever is in the COMMENT column to appear in column B bassed on the selection in column A.
I hope that makes sense
Last edited: