Need Macros to Create Bulk PDF

[noorul]

Hi Guys

I need a macro to generate PDF files for my employee list as per the sample, the sheet name is Payslip and as a sample

 

[jolivanes]

Maybe take some time and properly explain in detail in a concise manner what you need to achieve. The little picture does not tell us much.

 

[noorul]

Maybe take some time and properly explain in detail in a concise manner what you need to achieve. The little picture does not tell us much.

Sorry brother I have a Payslip voucher which captures data from Employees data. I managed to collect relevant data to generate a pdf voucher. Now I need a macro to print all 40 vouchers in 1 go.

 

[jolivanes]

Ok, now that you gave us all the relevant information, this should do the trick as per your explanation.

Sub Print_To_Pdf()
Dim i As Long
    For i = 1 To 40
        Sheets(i).ExportAsFixedFormat xlTypePDF, ThisWorkbook.Path & "\" & "Invoice " & Sheets(i).Name & ".pdf"
    Next i
End Sub