Pivot table filter - Selected Item Event
 

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

Pivot table filter - Selected Item Event
 

I missed to mention that -

"Is it possible to implement this in VBA"

Thanks

"Sreekanth" wrote:

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

Pivot table filter - Selected Item Event
 

On Sep 9, 1:09*am, Sreekanth
wrote:
I missed to mention that -

"Is it possible to implement this in VBA"

Thanks



"Sreekanth" wrote:
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- Hide quoted text -

- 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