Query on Category & Sub-category
Hi,
Do the following;
1. Create one sheet with data oraganized in a cloumn with appropriate
column heading in the first row of excel sheet.
2. Create a Pivot table in the other sheet using the data from Step 1.
3. Hide the sheet whcih contains the data
Note: Now when you refresh the Pivotable, the data will automatically get
data from your source ecxel sheet.
Challa Prabhu
"Santha Kumar" wrote:
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
|