# How to generate Pay Slip of all Employees

1. ## How to generate Pay Slip of all Employees

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.....

2. ## Re: How to generate Pay Slip of all Employees

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?

3. ## Re: How to generate Pay Slip of all Employees

Please find herewith the attach file

4. ## Re: How to generate Pay Slip of all Employees

Have I got another 5 months to solve this?

5. ## Re: How to generate Pay Slip of all Employees

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

6. ## Re: How to generate Pay Slip of all Employees

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

7. ## Re: How to generate Pay Slip of all Employees

Youv'e already got VLOOKUPS in the sheet

8. ## Re: How to generate Pay Slip of all Employees

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

9. ## Re: How to generate Pay Slip of all Employees

You don't need formulas,you need to set up the template to have the correct number of payslips for a sheet.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1