Hi, I'm looking for some help please. I know nothing about VBA coding/macros and need some help formatting an excel spreasheet to do the following:
1) Calculate payroll per employee
2) Generate Payslips
3) Print to PDF
I have a spreadshhet with 3 tabs... Payroll Info (Name, address etc), Payroll Calcs and the Payslip template. From what I have read online, I think I can use VLOOKUP to match the info and calcs to the payslip but can someone help me with the VBA code for the looping and printing to PDF. I would like to have one button to Generate & Print All Payslips.
The excel file is attached.
Your help will be much appreciated as I have hundreds of employees to process
Bookmarks