pivot table: Pagebreak after each item to PDF File

[haider378]

Salam to All,

I have a pivot table and my first filed is Month (A monthly Sales Report), I have insert the page break after each month using field setting dialog box and easily print the monthly sales report.

My requirement is to generate monthy pdf file (12 pdf files) using macro or any other shortcut

(It is urgent my director need email of these files)

Thanks

 

[General Ledger]

Not sure if this is will help but did you know you can print to a PDF rather than to paper?
Select File
Select PDF from list of printers or
Select Save and Send, and save as PDF.

 

[haider378]

normally we can generate pdf file selected print area in this case excel will generate one pdf file with 12 page. but I want to generate 12 pdf files using page break after each month in pivot table

 

[General Ledger]

Now I think I see. I am confident the solution requires a macro. Unfortunately, that is something I cannot provide to you.

 

[haider378]

so no solution