Hi - I have a pivot table that uses a large number of report filters.
These report filters each can have multiple selected values.
I would like to be able to capture the selections in the pivot table and store them in a worksheet so that at a later time, a user could reselect all of the specific combinations they made previously without having to reselect each of the report filters and reset them.

Example:
Report Filter 1: Possible Values A,B,C,D,E
Report Filter 2: Possible Values F,G,H,I,J
Report Filter 3: Possible Values K,L,M,N,O

User selected values:
Report Filter 1: A,C,E
Report Filter 2: F,G,I
Report Filter 3: K,L
this would be stored as scenario 1

I'd like scenario 1 to be available after the file has been saved/closed and reopened.