G
Guest
I have a master data in excel (Category & Sub-Category).
1. When I select on Product category, I should get the sub-category values
specific to that category.
2. I want to keep the master data seperate excel sheet.
Kindly let me know how to do this.
Excel Sheet1
Product Category Product sub Category
Prod1 Sub-Prod1-1
Prod1 Sub-Prod1-2
Prod1 Sub-Prod1-3
Prod2 Sub-Prod2-1
Prod2 Sub-Prod2-2
Prod2 Sub-Prod2-3
Prod2 Sub-Prod2-4
1. When I select on Product category, I should get the sub-category values
specific to that category.
2. I want to keep the master data seperate excel sheet.
Kindly let me know how to do this.
Excel Sheet1
Product Category Product sub Category
Prod1 Sub-Prod1-1
Prod1 Sub-Prod1-2
Prod1 Sub-Prod1-3
Prod2 Sub-Prod2-1
Prod2 Sub-Prod2-2
Prod2 Sub-Prod2-3
Prod2 Sub-Prod2-4