How to generate payslip and print it all at once

CYCLE THROUGH DV OPTIONS
Here's a basic macro for cycling through all the Data Validation options in a certain cell. The sample then prints out the workbook, but you can replace that line of code with whatever action you prefer, this should give you the basics.

Cycle Through Data Validation Options

The one edit that comes to mind is instead of printing the payslips (which may work for you and you're done..) you can export the sheet to PDF using the same cell reference as a filename source...

so this line:

Please Login or Register  to view this content.

...is replaced by something like this:

Please Login or Register  to view this content.