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.