Hi Doug,

Sorry for the delay, I've been pondering this request.

I've never seen a request of this nature, and thinking about it, I'm not sure that a worksheet with 15,000 rows is any improvement on a workbook with 150 worksheets or a PDF with 150 pages. The workbook and PDF would be easier to print. and all formats can use ctrl-f Find to quickly locate the information for a given department.

You can build a statement formatted to meet conditions 1-4 in your list, but the user would have to maintain the statement when new departments were added or departments decommissioned. This could be accomplished through a simple cut and paste operation, but it cannot be done automatically. I expect that pagination would immediately become an issue in a statement laid out this way.

We're getting close to Adagio Wish season. Perhaps others will jump in and express a desire for this type of automation.
_________________________
Andrew Bates