D
dwunderlin
I have time sheets that must be printed every week for over 100 people
and currently the supervisors type out the names, the pay scale, and
various other information about the personnel and then prints the
sheet. This process is repeated until all are printed. I have added
a validation list and some VLOOKUP codes to make the job a little
easier but it still take quite a bit of time to print out all the time
sheets for a week.
What I would like (if possible) to have is a macro that I can assign
to a button that when pushed a time sheet is printed each person and
auto complete their name from the validation list.
Is this possible?
and currently the supervisors type out the names, the pay scale, and
various other information about the personnel and then prints the
sheet. This process is repeated until all are printed. I have added
a validation list and some VLOOKUP codes to make the job a little
easier but it still take quite a bit of time to print out all the time
sheets for a week.
What I would like (if possible) to have is a macro that I can assign
to a button that when pushed a time sheet is printed each person and
auto complete their name from the validation list.
Is this possible?