Splitting Data into separate sheets

B

bernard

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup only when data exists in table 1
Multiple cells to look up and return values to another spreadsheet 1
Split worksheet into multiple worksheets 10
Generating new workbooks based on data 0
Rearranging the layout of data 3
Developing a reporting package 3
How do I consolidate data from several spreadsheets into one. 4
HELP! Find Data in columns next to known data then Calculate 2

Top