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
Bookmarks