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 :)