himajam
07-31-2019, 10:10 AM
Hi Excel Experts,
I'm looking for vba code for my below excel data. I couldn't figure out how to do it. Hope someone could help me
I have Product and Categories data (2 columns). For each Product, it should show me its corresponding Categories and on click of category, it should show me corresponding products.
Eg data:
Product Category
P1 C1
P1 C2
P2 C1
P3 C1
P3 C2
P3 C3
Output data:
P1 C1 If I click on C1, it should show me P1,P2,P3
---C2 If I click on C2, it should show me P1,P3
P2 C1 If I click on C1, it should show me P1,P2,P3
P3 C1 If I click on C1, it should show me P1,P2,P3
----C2 If I click on C2, it should show me P1,P3
----C3 If I click on C3, it should show me P1,P2,P3
I'm looking for vba code for my below excel data. I couldn't figure out how to do it. Hope someone could help me
I have Product and Categories data (2 columns). For each Product, it should show me its corresponding Categories and on click of category, it should show me corresponding products.
Eg data:
Product Category
P1 C1
P1 C2
P2 C1
P3 C1
P3 C2
P3 C3
Output data:
P1 C1 If I click on C1, it should show me P1,P2,P3
---C2 If I click on C2, it should show me P1,P3
P2 C1 If I click on C1, it should show me P1,P2,P3
P3 C1 If I click on C1, it should show me P1,P2,P3
----C2 If I click on C2, it should show me P1,P3
----C3 If I click on C3, it should show me P1,P2,P3