you could use an autofilter on the cost center column. ron debruin's site
details how to send emails.

http://www.rondebruin.nl/tips.htm

--


Gary Keramidas
Excel 2003


"BabyMc" wrote in message
...
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?