Pivot table filter - Selected Item Event

[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

 

[Sreekanth]

I missed to mention that -

"Is it possible to implement this in VBA"

Thanks

 

[Madiya]

I missed to mention that -

"Is it possible to implement this in VBA"

Thanks









- Show quoted text -

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