Hello,
*SOLVED* 2 solutions provided
I would like to have dependent drop-down menus.
I have one column for THEMES and another for TASKS. The tasks are associated to themes. I should get a different list of tasks for each theme I select.
So far, I would say that I have 90% of the solution.
I created my THEMES column, cell A4:A8, using the classic drop-menu. There are 13 themes.
I have created my TASKS column, cell B4:B8, using Formulas-Create from Selection and Data Validation List.
It works for the most part. Here is the problem: only 11 of 13 themes work. I mean that only 11 of the 13 drop-down menus of tasks associated to themes appear. I cannot see the first theme, which is SELECT, nor can I see the last, which is RESEARCH. (See attached)
Bookmarks