How do I print all items in a dropdown list? Over 145 names in list? Please help

Hi,

I'm new to the forum and this is my 2nd post. Here is my problem, I hope there is a way to make this easier. Thanks in advance.

I have about 145+- employees and I made a simple spreadsheet that allows me make a timesheet for every employee. However, I do not want to sit here and select each employee's name and press print 145+ times. Is there another way to do this?

All I would like to do is press print or run a macro and 145 sheets pops out. I have to do this weekly and it would take me an hour to individually do this.

I've uploaded the timesheet and any help would be much appreciated.

This macro assumes that the sheet "VST 031734" is the active sheet when you run the macro "PrtEmp"

Please Login or Register  to view this content.

Alf