View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Madiya Madiya is offline
external usenet poster
 
Posts: 239
Default 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