Hi

I have a excel work sheet for salary calculation. Sheet1 has database of
employee number, Name, Salary etc. Sheet2 has a nicely formatted pay slip
based on the employee data on Sheet1. I use a pull down menu to select the
Name of the employee and corresponding salary details are displayed in the
pay slip. I then take a print out for the given employee. However it is time
consuming because I have to change the employee name manually for each
person and issue a print command.

Is there a way I can automate this? I mean click a button and excel can
print the pay slip for the entire employees in the database using the pay
slip format in Sheet2?

I would appreciate any pointers in this regard. My knowledge of VBA is very
poor.

Thanks for any help in advance.

Best regards
Aseef