Creating a multi-select list that is dependent on another multi-select list

[amujahid]

I hope someone can help me. I am not a programmer so I struggle with code, but I have been managing with the form controls and data validation options in Excel and have created a pretty nifty form. However, I am struggling with one final piece:

I need to create a multi-select list in Column A. This is a list of possible HEALTH TOPICS.

I need to create a multi-select list in Column B that is dependent on the selections made in Column A. This is a list of SUB-TOPICS.

Example:

In Column A, I select Cancer and I select Diabetes.
In Column B, I want to see only the sub-topics which are applicable to Cancer and which are applicable to Diabetes.

What is the best way to do this? Any help would be greatly appreciated.

Thanks in advance!!

 

[Elizabethd1012]

Does anyone have a response for this? I have to do the same thing and need help!

I hope someone can help me. I am not a programmer so I struggle with code, but I have been managing with the form controls and data validation options in Excel and have created a pretty nifty form. However, I am struggling with one final piece:

I need to create a multi-select list in Column A. This is a list of possible HEALTH TOPICS.

I need to create a multi-select list in Column B that is dependent on the selections made in Column A. This is a list of SUB-TOPICS.

Example:

In Column A, I select Cancer and I select Diabetes.
In Column B, I want to see only the sub-topics which are applicable to Cancer and which are applicable to Diabetes.

What is the best way to do this? Any help would be greatly appreciated.

Thanks in advance!!