Payslip Printing & Error while Wrong Emp Code

**koolguys4u** · 03-13-2010, 05:14 AM

I have a excel file wherein a sheet1 is data which contains data related to employess payroll.In another sheet payroll,payslips are there. but as I want only one payslip to appear.The problem is now that I want to print individually in the present manner.So I want a Function Formula which will give print payslips with two options: Print payslips for all employess,print payslips for individual employees or range of employees. Sample Sheet attached for reference...

And if i entered any wrong employee code the formula in payslip displays #N/A.

Please rectify the same in Payroll sheet..

Md Pasha

**koolguys4u** · 03-23-2010, 07:05 AM

Any one can help me

**buran** · 03-23-2010, 07:11 AM

It doesn't make sence to ask the same thing in two different threads:
http://www.excelforum.com/excel-prog...employees.html

**royUK** · 03-23-2010, 02:45 PM

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.

I also seemto be wasting my time,you haven't even used the code that I wrote for you!