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
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Pivot Table; Naming Report Filter Selection 1
- Thread starter jpgactmod
- Start date
-
1
- #2
SkipVought
Programmer
hi,
Turn on your macro recorder and make you SELECTIONS.
Then turn it off.
Skip,
[sub]
![[glasses]](/data/assets/smilies/glasses.gif "[glasses] [glasses]")
Just traded in my old subtlety...for a NUANCE!
![[tongue]](/data/assets/smilies/tongue.gif "[tongue] [tongue]")
[/sub]- Thread starter
- #3
SkipVought
Programmer
If you need help customizing your macro (VBA), you'll get the best responses in forum707.
Skip,
[sub]
Just traded in my old subtlety...for a NUANCE!
[/sub]- Status
