Closed Thread
Results 1 to 9 of 9

How to generate Pay Slip of all Employees

  1. #1
    Registered User
    Join Date
    06-07-2009
    Location
    UAE
    MS-Off Ver
    Excel 2003
    Posts
    61

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

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

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    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?
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    06-07-2009
    Location
    UAE
    MS-Off Ver
    Excel 2003
    Posts
    61

    Re: How to generate Pay Slip of all Employees

    Please find herewith the attach file
    Attached Files Attached Files

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: How to generate Pay Slip of all Employees

    Have I got another 5 months to solve this?

  5. #5
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: How to generate Pay Slip of all Employees

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

  6. #6
    Registered User
    Join Date
    06-07-2009
    Location
    UAE
    MS-Off Ver
    Excel 2003
    Posts
    61

    Re: How to generate Pay Slip of all Employees

    Thanks for prompt reply.....


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

  7. #7
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: How to generate Pay Slip of all Employees

    Youv'e already got VLOOKUPS in the sheet

  8. #8
    Registered User
    Join Date
    06-07-2009
    Location
    UAE
    MS-Off Ver
    Excel 2003
    Posts
    61

    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. #9
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    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.

Closed Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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