You could create a Pivot table report and put the the Bank field in
the "Page field" area. A separate report for each bank would be
dynamically created when you choose each bank from the dropdown box.


HTH,
JP

On Nov 9, 2:17 pm, break one rpt into multiple rpts
.com wrote:
I have created an excel report with column headings and data for 500
individual banks. I would like to take this report, and create 500 separate
reports, one for each bank. Is this possible?
Thanks!