Pivot Table; Naming Report Filter Selection 1

[jpgactmod]

I created a Pivot Table with multiple selections from a Report Filter. My question is once I make a selection is there any way to name the selection so I can retrieve the same selections from the Report Filter without having to remember and make the same selections each time? Any help would be greatly appreciated. Thank you. Jim

 

[SkipVought]

hi,

Turn on your macro recorder and make you SELECTIONS.

Then turn it off.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[jpgactmod]

Thanks much Skip!!

Jim

 

[SkipVought]

If you need help customizing your macro (VBA), you'll get the best responses in forum707.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}