Dear All,
I want to create a dynamic dependent list. A test sheet is attached. In source table, each product category has different products against it.
I made a list in Product table under product category. What I need is that when I select a category "A" in Product table, a list should appear in Product name (in Product table) corresponding to "A" in Source table and when I select "B", product name items corresponding to "B" shroud appear in the list, so on.....
I believe that you can solve my problem very easily.
Please see the attached sheet (DependentList) for reference.
Thank you.
I want to create a dynamic dependent list. A test sheet is attached. In source table, each product category has different products against it.
I made a list in Product table under product category. What I need is that when I select a category "A" in Product table, a list should appear in Product name (in Product table) corresponding to "A" in Source table and when I select "B", product name items corresponding to "B" shroud appear in the list, so on.....
I believe that you can solve my problem very easily.
Please see the attached sheet (DependentList) for reference.
Thank you.