ListBox Selections To Change ReportFilter on PivotTable and then Execute Macro

[EnigmaMatter]

Hello,

I have created a ListBox1 that is populated by a PivotTables(1).PivotField(6) (which is a Report Filter called "Select Customer"). I could not figure out how to use PageField to select the Report Filter, so I did a work around.

Please Login or Register  to view this content.

I am now attempting to change the Report Filter in the PivotTable to match the selection made in the ListBox1. I then want a macro to execute on that selection. I then want it to repeat the process for each selection made.

Please Login or Register  to view this content.

There is probably a much easier way to do this? Can anyone help?

[arlu1201]

Is this solved?

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.

[EnigmaMatter]

arlu1201,

I appreciate the top on forum etiquette. I did the task very differently, but it did achieve the result.

As requested, here is the code that "solved" the thread.

Please Login or Register  to view this content.

The CreateUsageReportsFromSelections is a macro that performs the task of copying the page, creating a new Sheet, renaming the new Sheet, formatting the new Sheet; in other words, basic macro.

[arlu1201]

Thanks for posting the solution.