• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Storing Favorite Pivot Table Report Filter Selections with Multiple Items

Marston

New Member
I have a large pivot table.

The pivot table has 10 different report filters.

Each of the filters has several items - some with as many as several thousand.

I would like to be able to store the selections from a pivot table somewhere so that they can be used to reset the pivot table report filters to previously set combinations. The storing must be outside of memory so it is available when the file is reopened.


Example:

Filter 1: Possible options: A,B,C,D

Filter 2: Possible options: E,F,G,H

Filter 3: Possible options: I,J,K,L


User selects

F1: A,C

F2: E,F,G

F3: I,K


- store as scenario 1


User selects

F1: B,C

F2: E,F

F3: J,K,L


- store as scenario 2


and so on.


Thanks in advance


Marston
 
Marston


Firstly, Welcome to the Chandoo.org Forums


Why not record each setup from scratch using the Macro recorder

and then link each to a button to execute that as required
 
Back
Top