I'm trying to setup excel payslips. I have created a work sheet with employee data and use sheet 2 which has payslip. I have used vlookup to fill emplyee details. Is it possible to generatea seperate pdf file for ach employee rather han doing each payslip manually?
i'm attaching a test file which i have created which would resebmle the real data.