Automating and Emailing Pivot Table Reports
Here's the scenario: I want to send different pages of my pivot table report to different email recipients. I can do this by hand but it takes forever to change the filter, copy/paste, or export the report and then create and send the email, even just for a few people. And when I do this …