I have a report that contains a number of columns - and where the report
contains a number of lines for a range of 'cost centres'.
The report has the cost centre title in one column (say B) and then a number
of rows below that containing various data in the columns.
At the moment the cost centre is only identified in the first row of each
cost centre's data.

At a point the data for one cost centre is concluded and the next row
contains the data for the next cost centre - and so on.

How may I 'split' this report - I guess in to a workbook for each cost
centre so that I can send (via email) to individuals?