Excel slicer? how to automate the selection of values and printin PDFs?

[deadeye123]

I have a slicer that has multiple values. the slicer controls multiple pivot tables. I need to select each value in the slicer and print a PDF. there are 100 values in the slicers and do it manually is a time consuming. how do I automate the process via macros or modules?

 

[Joe4]

Duplicate: http://www.mrexcel.com/forum/excel-questions/982591-slicer.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #12 here: Forum Rules).

The proper thing to do is to *bump* your own thread by replying to it yourself (you may have seen some people do this). I usually recommend giving at least 24 hours before doing so (some people bump sooner than that, and that removes the thread from the list of recent unanswered threads, so that could have an "adverse" affect).