Splitting Data into separate sheets
 

I export a Crystal report into Excel - the report is about 36000 lines long.
This report contains financial data for, say, 20 different cost centres. I
would like to be able to 'cut and paste' each cost centre onto a new sheet in
my workbook.

Each set of Cost Centre data is indicated in column A on the spredsheet with
the word 'Cost Centre' followed by the Cost Centre code itself, e.g.

Cost Centre 000001
123.45
3256.56
987.95

Cost Centre 000002
98.87
999.66
99.77
777.88
111.22

Cost Centre 000003 etc

Is there any way a macro could help with this? Thanks in advance.

Bernard