How do I separate a worksheet into many files?

[Alicia]

I have a list of data, company names with values and the subtotal for each
company. I would like to make a separate file for each company. Company
Names are listed in column A, one company may appear numerous times,
depending on how many corresponding values it has. So it says company x
however many times in column A, and then it says Company X total. Then it
says Company Y however many times, then it says Company Y total, etc. Right
now all of the information is in one worksheet, but there are like 300
companies (therefore, I need 300 files.) Is there any way to do this?

[Ron de Bruin]

Hi Alicia

Try this one
http://www.rondebruin.nl/copy5.htm


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


"Alicia" <Alicia@discussions.microsoft.com> wrote in message news:C73A629D-B63D-451E-9525-D4A96F8DFC19@microsoft.com...
>I have a list of data, company names with values and the subtotal for each
> company. I would like to make a separate file for each company. Company
> Names are listed in column A, one company may appear numerous times,
> depending on how many corresponding values it has. So it says company x
> however many times in column A, and then it says Company X total. Then it
> says Company Y however many times, then it says Company Y total, etc. Right
> now all of the information is in one worksheet, but there are like 300
> companies (therefore, I need 300 files.) Is there any way to do this?