Discussion Article

[ Home | Contents | Search | Reply | Previous | Next ]

Subject:
macro code to print all or individual records
Name:
Sujit
Email (spam proof):
Email the originator of this post
Date:
Friday, May 11, 2007
Hits:
68
Discussion (Terms and Conditions):
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.

Sponsored by the best FTP application on the internet: