Creating a Dependent Drop Down List from Multiple Data (Multiple Select using VBA) in One Cell

Hi Community,

I'm trying to create a second dependent drop down list but the data I want it to be dependent on as multiple data value in a cell which is inserted from a drop down list. I have used VBA code to make it a multi-select drop down so multiple data can be selected in the cell. This can be seen on the attachment under the Technology Area Column, you can select multiple areas. The second column i'm trying to create is under the Portfolio column. I've created the data set under Sheet 2.

The data in the first drop down are technology areas and the second drop down i'm trying to create is the individual technology components within the area. How can I create this?

Thanks