Pivot Table Drop Downs
 

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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200804/1

Pivot Table Drop Downs
 

Please Respond :( (Some one please help)

dinadvani wrote:
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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200804/1