Pivot Table Drop Downs

  • Thread starter dinadvani via OfficeKB.com
  • Start date
D

dinadvani via OfficeKB.com

Hi,

I need your help on the below problem.

I want to create a macro that can be used on multiple sheets. I have created
a pivot table but the thing is pivot drop downs are giving me problems. The
column in pivot header is common for all the sheets except the last 3 words
(for example Report 1 - ABC, Report 1 - BCD) now i am looking out for
something similar to what we do in autofilter - search with contains or
begins with.

But i am unable to find a solution. Please help as i can't create macros for
all the sheets....

Thanks for your help.

Regards,
DA
 
D

dinadvani via OfficeKB.com

Please Respond :( (Some one please help)
Hi,

I need your help on the below problem.

I want to create a macro that can be used on multiple sheets. I have created
a pivot table but the thing is pivot drop downs are giving me problems. The
column in pivot header is common for all the sheets except the last 3 words
(for example Report 1 - ABC, Report 1 - BCD) now i am looking out for
something similar to what we do in autofilter - search with contains or
begins with.

But i am unable to find a solution. Please help as i can't create macros for
all the sheets....

Thanks for your help.

Regards,
DA
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Doughnut Chart linked with the slicer in the pivot table 0
Pivot table drop downs stop working 0
Slicers and Calculated Items in Pivot Table 2
Pivot Table Refresh? 1
Pivot table drop downs not refreshing 1
Can Pivot table drop-downs act like AutoFilter 1
Dynamic Naming of Form Button 3
Playing back a Pivot Table macros 2

Top