Creating a selector program - help creating the dropdown menus

[MattP299]

I'm trying to make a selector guide. I have a tab (Data) with 8 columns (A-H) having product discriptors (name, number, and various properties). Columns J-Y are catagories that the particular products are used for. Listed by Industry then Market segment. The Headings J1-Y1 are the industry names: (J1-O1) Industry A; (P1-T1) Industry B; (U1-Y1) Industry C. Under those (J2-Y2) are market segments. Listed under the market segments there are X's indicating what industry and market segment the product is useful. I need to have a drop down list on the first tab (Selector) for a user to pick a market segment and have a 2nd dropdown menu displaying the market segment in that industry. When the 2nd dropdown menu choice is made I would like to have a list generate under the dropdown menus displaying all products that can be used in that market segment. The list should show all the information in the first 8 columns (A-H) on the Data tab. Does anyone know how to go about doing this?

I have attached an example of what I have so far. ANY help would be greatly appreciated as I've been stuck on this for 3 days =(.

Thank you.

[barryleajo]

Hi MattP299
Better late than never but try the attached
Barry

[MattP299]

Barry,

This is exactly what I'm looking for. Now I have to try to figure out from your example how to do this for the actual file. I can't post it on here because of the policies of the company I'm working for.

Thank you very much, now I hope I can figure out how you did this and make it work for me =)

[barryleajo]

That's great Matt
Let me know if you need any further explanation.
In the meantime please mark your thread as SOLVED
Barry