Need Help with Printing Payslips using Macros In excel 2007

I have a excel file wherein a Sheet1, which contains data related to employees payroll.In another sheet 2 (Pay Slip) the payslip is available. I want the details in the payslip to be filled with the details mentioned in Sheet1 and want it to be printed individually according to the serial numbers. Can I get a Function Code which will print payslips for all employees individually with the details required in the payslip.

I attached here a sample copy of the excel data. The sheet two is the formatted payslip.

Kindly help!

Shafraz Abdulla

thank You Kamboj Can you explain me how to get the rest of the details using VLOOKUP

thanks a lot .. i understood the logic ... i wanted to know the logic that's why i told u to explain. ur explanation was awesome.

Dear Sir,

I am still having problems with this document, I have been trying to do it by my self and trying to find solutions but since i am new to this side of excel (using high end functions and Macros) I am finding it hard to grasp.

the drop down box which u have done to show the details of employees in the payslip form is not giving me the details any more since i had added that work sheet in to my main document and tried to follow the steps u had given me. but i was not successful. the again i went through help and used data validation but it is not allowing me choose the selection i want because the selection is not in the same worksheet.

and i want to print all the work sheet separately and the people individually.. please help me with this problem and explain the way you did it to me as well so that i can understand.