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

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