How to generate Pay Slip of all Employees

**koolguys4u** · 10-17-2009, 07:15 AM

Dear All,
I have around 250 Employees Payroll and i am preparing the Payslip in Excell manully. I have all the Salary details in Sheet1 and in Sheet2 is Payslip. I request all of you to please help me so that i can take the printout of all the employees in sheet1 by at a time. Now im entering one by one employees code and then taking the prinout..
Please provide me with any Formulas as micros are disable in my Computer.....

Waiting for an early reply.......

**royUK** · 10-17-2009, 07:25 AM

You would need to use VLOOKUP.

That's the best I can offer unless you post an example workbook. The task could be easily automated using macros, why are macros disabled?

**koolguys4u** · 03-17-2010, 05:20 AM

Please find herewith the attach file

**royUK** · 03-17-2010, 03:40 PM

Have I got another 5 months to solve this?

**royUK** · 03-17-2010, 03:57 PM

Try this, I have added a button to print all the slips.

**koolguys4u** · 03-20-2010, 10:42 AM

Thanks for prompt reply.....

Please give me through formula VLOOKUP. or any other formula and

**royUK** · 03-20-2010, 11:01 AM

Youv'e already got VLOOKUPS in the sheet

**koolguys4u** · 03-23-2010, 02:13 AM

Dear SIr,

I want any Formula to Print or atleast generate all employees Payslip in One Excell Sheet in A5 Paper size so that we can Print all Payslip in one time...................

Md Pasha