Generate payslips from the data given

On sheet2 of your example, why don't you for our information and avoid any guessing, indicate the column that the data comes from on sheet1. In this manner, it can then be automated with the exact information you require. Help us to help you.

In addition to what Alan is asking for there's some other considerations. What do you want each payslip(tab) to be named, keeping in mind there's a 31 character limit in the name.

Another issue is if you are keeping the information in sheet1 for every pay period you will need a column, perhaps labeled payslip, that could be flagged(yes/no) for only those line items for which you want a payslip generated.

Originally Posted by skywriter

In addition to what Alan is asking for there's some other considerations. What do you want each payslip(tab) to be named, keeping in mind there's a 31 character limit in the name.

Another issue is if you are keeping the information in sheet1 for every pay period you will need a column, perhaps labeled payslip, that could be flagged(yes/no) for only those line items for which you want a payslip generated.

i want the tab to be the name of the employee

i am looking for generating payslip for all the employees

i want the tab to be the name of the employee

So then next time you generate payslips you are going to delete all the previous payslips?

i am looking for generating payslip for all the employees

So the sheet1 that you want to generate the payslips from will not have any data from previous pay periods?

Make sure you respond to Alan's post, #2.

Originally Posted by sebastiand95

Hi thank you for the prompt reply
i have updated the file
it would be great if you could even tell how your going to use a macro

For every employee on sheet1 the code will first make a copy of sheet2 to use as a template and name the copy with the employee name per your instructions. Then the appropriate information from sheet1 will be pulled into the new payslip and the process repeated until the last employee. Any required formulas should just be present in the blank payslip sheet, they should not reference sheet1 but just other cells on the payslip.

Check this for accuracy and let me know if you need any changes or fixes.

It takes information from your sheet1 and puts it into sheet2. It uses the name of the employees to name their sheets as you requested. The reason Alan asked about what you wanted in which cell is because you have much more information on sheet1 than you are wanting to put on sheet2.

It's simply a matter of copying your sheet2, naming it with the name of the person in the row we are currently concern with and setting the values on the new sheet according to your preferences from sheet1.

Thanks for the rep. points.

Please click the Thread Tools drop down box above your first post and choose solved.

Here you go.

Please Login or Register  to view this content.

Thanks a lot.
Sir any code to convert each sheet into a pdf?

Originally Posted by sebastiand95

Thanks a lot.
Sir any code to convert each sheet into a pdf?

That's different than your original request.
Please start a new thread and I'm sure someone will be glad to help.