Save to PDF Instead of Excel

Hi... i have the below code, that takes a list of transactions of various customers, moves the data for each customer to a 'formatted statement', and saves it in excel.
I want to change the code so it saves is as PDF instead. Can someone help me adjust the final piece of code please. Many thanks

Please Login or Register  to view this content.

Try

Please Login or Register  to view this content.

instead of

Please Login or Register  to view this content.

Thanks for the quick reply... ERROR.png

Please Login or Register  to view this content.

Thankssss - Sorted.

One more thing.... I added some rows at the top of the format sheet and it seems to have messed up the code

What was in Row 1 - is now in Row 11 - Name of Customer
What was in Row 2 - is now in Row 12 - Col Headers
What was in Row 3 - is now in Row 13 - The Data

I changed what i understood as per below.... but i seem to be loosing the 'Col Headers' for sure in the output.

Please Login or Register  to view this content.

Hi, can you attach a sample workbook?

as a guess, which worksheet do yo need to export as PDF,Ash (Data) or Dsh?
if Dsh, try

Please Login or Register  to view this content.

instead of

Please Login or Register  to view this content.

FILE ATTACHED....

Another issue is that when there is a lot of data, for the same client, I do not get the header on the second page / and also page number, (Page 1 of 1) etc.


FV SOA Creation.xlsm

Amazing help. Thanks.