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
|