need a macro to loop thru names in a drop down list for a timesheet

[radarzdc]

timesheets.xls


see attached file

I need to print several timesheets, each with a different name and employee ID number that can be found in a drop down list and table.

can somebody teach me the vba code to make that happen?

any help is appreciated!

thanks,

radarzdc

[davesexcel]

Copy and paste this code in a regular module.

Please Login or Register  to view this content.

Click on your colorful picture to run the code. After you have tested it, remove the PrintPreview line and delete the apostrophe that is in front of the Activesheet.Printout line.

[radarzdc]

Dave,

Worked perfectly. But when I merged 2 cells, it stopped working! Can you help again?

Thanks for the help!

radarzdc

[radarzdc]

here is the file that doesn't work...what did i do wrong in the macro??

[davesexcel]

Column O is column 15 not column 29. Change 29 to 15