Print multiple sheets from a validation list

  • Thread starter Thread starter dwunderlin
  • Start date Start date
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?
 
Hi,

Since you already have a list of all the employees in your validation list,
here is a simple solution. Suppose the list used by data validation is
located in the range L1:L100 and your data validation drop down is located
in A1.

Sub PrintAll()
For Each cell In Range("L1:L100")
Range("A1") = cell
'Print
Next cell
End Sub

I would record the print command you are currently using and put that code
in the Print line above.

You can simplify this code to read

Sub PrintAll()
For Each cell In [L1:L3]
[A1] = cell
'Print
Next cell
End Sub

Attach this code to a button.

Cheers,
Shane
 
Back
Top