Split worksheet into new files
 

Hi all,

I have a spreadsheet with about 2000 rows of information (15 columns),
and the first column represents what I'm wanting to split by. Of the
2000 rows, there are 28 different possibilities.

What I'm trying to do is split the worksheet into 28 different files,
based on what's in the first column.

For example, let's say the first row is (where the represents a tab):

America Monkey Tree

And the second row is:

Australia Alligator Swamp

I would want to create a new file named America.xls (or .csv, or .txt;
that doesn't matter) with the first row of:

Monkey Tree

At the same time, a second file named Australia.xls would be created,
and so on and so forth.

Is there an automated way to do this?

TIA,

Jason

Split worksheet into new files
 

hi Jason

See
http://www.rondebruin.nl/copy5.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Jason" wrote in message ups.com...
Hi all,

I have a spreadsheet with about 2000 rows of information (15 columns),
and the first column represents what I'm wanting to split by. Of the
2000 rows, there are 28 different possibilities.

What I'm trying to do is split the worksheet into 28 different files,
based on what's in the first column.

For example, let's say the first row is (where the represents a tab):

America Monkey Tree

And the second row is:

Australia Alligator Swamp

I would want to create a new file named America.xls (or .csv, or .txt;
that doesn't matter) with the first row of:

Monkey Tree

At the same time, a second file named Australia.xls would be created,
and so on and so forth.

Is there an automated way to do this?

TIA,

Jason

Split worksheet into new files
 

Wow, that was really perfect. I appreciate that!

Jason

Split worksheet into new files
 

You are welcome

Thanks for the feedback

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Jason" wrote in message oups.com...
Wow, that was really perfect. I appreciate that!

Jason