Hi Gaba. I am a little unclear what you have and what you are looking for in
the end. First a line looks like this with an X between data elements?:

Chromium X < 5 X mg/L X 1 X 0.005 X EPA 200.8 X 10/15/2004

This line and maybe several other lines will have a "Group' header, some
thing like:
3964-1.1

You need these lines put in a separate workbook or worksheet? Maybe a
worsheet for each group, but in their own workbook? They already exist on an
Excel worksheet with each "group" separated by a column. This starts in cell
E50, so the next group starts in cell M50? How many groups do you have? If
each group had its own worksheet in this same book would that be sufficient?
Maybe each sheet shuld be named with the name of the group?

Thanks,
David

"gaba" wrote:

Hi All,
I'm trying to create a macro to do the following:
I have a Sheet with result groups, say they start on cell E:50. Each group
is separated by a column.

Each result group looks like this

3964-1.1
Chromium < 5 mg/L 1 0.005 EPA 200.8 10/15/2004
Cobalt < 5 mg/L 1 0.005 EPA 200.8 10/15/2004
Nickel < 5 mg/L 1 0.005 EPA 200.8 10/15/2004
Cadmium < 2 mg/L 1 0.002 EPA 200.8 10/15/2004
Tin < 5 mg/L 1 0.005 EPA 200.8 10/15/2004
Lead < 3 mg/L 1 0.003 EPA 200.8 10/15/2004

It can be one or more results. I need to create a Copy of the workbook with
each result group (always 7 columns, number of rows varies)disregard the
others and save it in the same folder with the First cell value (in this case
3964-1.1) .

It is possible? Any help would be greatly appreciated
--
gaba :)