A macro would do fine--I guess I am just not sure how to set it up. I have a
list of facility numbers in row K that I used the for the data validation
list, which of course is on the same spreadsheet as the report that I want to
print. Any clue on how I would get started?

"Ron de Bruin" wrote:

Hi SJC

You can do it with a macro.
Do you want that ?

Do you have a list with facility names on a sheet and use that
range for the Data Validation list ?

--
Regards Ron de Bruin
http://www.rondebruin.nl


"SJC" wrote in message ...
I have created a workbook which reports facility data trends. I created a
standard report to report this data for each facility. To create each
facility's scenario, I used a data validation list with a drop box of
facility names to create a standard report for each facility. Obviously only
one report may be seen and printed at one time. Is it possible to print out
all scenarios in the validation list, or do I need to print each report one
at a time. Thanks in advance for any help.