sujittalukde
05-12-2007, 04:03 AM
I have a excel file wherein a sheet in database form is kept which contains data related to employess payroll.In another sheet,payslips are there. but as I want only one payslip to appear, so I have made the same using Validation dropdown list & VLookup function.The problem is now that the user has to select individual employee name from the drop down list & then to click the print as the no. of records are rising, it is not possible to print individually in the present manner.So I want a macro code which will:
1. Give users to print payslips with two options: Print payslips for all employess,print payslips for individual employees.
2. To print the all payslips, one page of A4 size should accomodate only at most 16 to 20 rows so that payslips can be later on torn out separately.My payslip format uses four(4) rows for one pay slips.
1. Give users to print payslips with two options: Print payslips for all employess,print payslips for individual employees.
2. To print the all payslips, one page of A4 size should accomodate only at most 16 to 20 rows so that payslips can be later on torn out separately.My payslip format uses four(4) rows for one pay slips.