Pivot table filter - Selected Item Event

S

Sreekanth

I have a Excel sheet where two Pivot table filters are populated from data in
another sheet. The filters are Country and States.

If a country is selected, the state filter should be populated with States
for that Country.

Is this possible to do in Excel on Pivot table ?

Thanks for any response and links (ideas)

-S
 
M

Madiya

I missed to mention that -

"Is it possible to implement this in VBA"

Thanks









- Show quoted text -
Click to expand...

Sure.
Start macro recorder and do the same thing
Stop recorder and have a look at code generated.

You may need to modify certain code.

Regards,
Madiya
 
Top