Hi All,

I have created a report template that has a dropdown list. Selecting one of the projects it shows all the data that Project Managers would like to see.

What i would like to do is press a command button to print each project, one at a time. In addition, I would like it to also only print the rows shown (i don't mind a few extra rows).

Dropdown list is in D1. the smallest report is one row... the largest is 127 rows.

Thanks,
Mark