I need to print an employees payslip:

I have already created a template of payslip in a worksheet and the payslip is generated using drop down menu of employee name and vlookups.

Now i want them to print the payslip of all employees listed on the dropdown list all at once, instead of selecting a name then print.

also the filename should be based on the employee name, and it should directly print, no more interaction.

In short, when i click a the print button all payslip will be generated to a certain folder.


Thanks in advanced!!!