Extracting report filter values when (Multiple Items) have been selected

[zzafish]

Hi All,

I've spent some time searching for an easy way to extract the values of a report filter when multiple items have been selected on a pivot table and have been unable to find one. I'd like to use the values to label a chart with the relevant information from the filter selection. I've found lengthy macros that can do the job, but I'm looking for something simple. Does such a thing exist?


Thanks!

 

[Hui]

ZZfish


Welcome to Chandoo.org Forums


I often use a technique of linking a Dynamic Range to a Pivot Table to extract unique lists

I posted about it here, a few days ago

Look at my last post in: http://chandoo.org/forums/topic/extracting-multiple-entries