Export pivot table to individual PDF files

This is perfect if you have a pivot table, and you want to export multiple versions of it to separate PDF files, eg. a report per manager or OpCo to distribute further.

In this case I have a pivot table called PivotTable1 on the worksheet called Summary, and I want to export a PDF file for each value in analyis_codes4 available in the pivot table. The files will in this case be saved in directory C:\EXPORTDIRECTORY\.