I need to print payslips for our employees as we do not have a dedicated payroll software to do this.
Here is what I want to do. I want to have lower area of the worksheet as a template and the upper area to hold all payroll information and I want Excel to pickup the information from uppaer area and transpose that to the template and print. After printing the record in the 1st row it should move down and repeat until all the records are printed
Here is what I want to do. I want to have lower area of the worksheet as a template and the upper area to hold all payroll information and I want Excel to pickup the information from uppaer area and transpose that to the template and print. After printing the record in the 1st row it should move down and repeat until all the records are printed