+ Reply to Thread
Results 1 to 5 of 5

How can I print the salary slip for everyone with one click?

  1. #1
    Registered User
    Join Date
    03-16-2014
    Location
    Yemen
    MS-Off Ver
    LAST ONE
    Posts
    7

    How can I print the salary slip for everyone with one click?

    How can I print the salary slip for everyone with one click?

    Please open the attached to know exactly what I am looking for.
    I have prepared the attached file to prepare employee salaries but let’s see that we have around 500 or more employees. How can I print the salary slip for everyone with one click?
    Be informed the salary slip is already set (I mean set print area). So I need the Excel go to the first employee and copy his data from the first row A5:AG5 and paste it in row A2:AG2 automatically then the print has salary slip.
    Again automatically start with the second row A6:AG6 and paste it in row A2:AG2 automatically then the print has salary slip.
    And so on
    But stop wit the last serial number or the last cells full with values.

    Please Heeeeeeeeelp
    Attached Files Attached Files

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,619

    Re: How can I print the salary slip for everyone with one click?

    Try short macro:
    Please Login or Register  to view this content.
    PS. for first trials may be try only few rows like:
    Please Login or Register  to view this content.
    Last edited by Kaper; 03-20-2014 at 04:47 AM.
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    03-16-2014
    Location
    Yemen
    MS-Off Ver
    LAST ONE
    Posts
    7

    Re: How can I print the salary slip for everyone with one click?

    I run the code but I faced this [ Run Time error 424] Object is required.
    Please check it out.

  4. #4
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,619

    Re: How can I print the salary slip for everyone with one click?

    Well, As I was writing it on the forum, not in the VBA editor, there was a misspelling . See edited post with green correction.
    I added also formula to A2:
    Please Login or Register  to view this content.
    See attached file
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    03-16-2014
    Location
    Yemen
    MS-Off Ver
    LAST ONE
    Posts
    7

    Re: How can I print the salary slip for everyone with one click?

    Wow Wow Wow. Really Thank you for your efforts. marvelous .
    Thank You So Much.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 8
    Last Post: 09-06-2013, 05:57 AM
  2. Replies: 8
    Last Post: 05-11-2013, 07:00 PM
  3. I need a formula in excel for my Salary slip ....!
    By Abdullah Ahmad Ali in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 02-15-2012, 06:20 AM
  4. Print Packing Slip # Increase
    By bguenther in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-20-2008, 08:55 PM
  5. How to automatize Salary slip preparation using EXCEL and a WORD-template?
    By ravikiran in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-05-2008, 08:39 AM

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