Marica

Few queries
1. If you have headers repeated for each cost centre, why dont you split by
the header rather than 2alpha/2numeric entry in Column A.. OR do you forsee
any issues
2. Report spans to which column..(not really needed but still)
3. Do you need the formatting Or just the data in the new sheets..

If this post helps click Yes
---------------
Jacob Skaria


"Marica" wrote:

I need to split a worksheet into multiple worksheets. The report pulled from
Dynamics creates one excel worksheet for multiple cost centres. I need to
split the report so that every cost centre is on a different worksheet. The
reports have different lenghts so I cannot make use of a "every 100th line"
approach. The common denominator is that when a new report starts column A
has a value with 2 alphabetical characters and 2 numerical characters. Can I
somehow make use of this to indicate to excel to split the report when it
encounters a value with 2 alphabetical characters and 2 numerical characters
in Column A?

Example:

REPORT HEADING
HO13 data
data
data etc
REPORT HEADING
LB17 data
data etc

The result I require is that HO13 will remain on the current worksheet and
LB17 will move to a new worksheet (including his report heading). Please keep
in mind that I might have more than 2 cost centres on the report (this will
also vary with every report generated).

If anybody could be of assistance I would greatly appreciate. Please provide
the explanation for dummies.

Thanks