[VBA] Creating sheets based on criteria

Hi

I have a workbook with something like 25000 rows and 40 columns. I would
like to split this into about 45 seperate workbooks based on values in
certain rows.

Example: K2:K25000 contains the values null, EEP, CHKN and LFAN. O2:O25000
contains the values null, MICO and MKA. I would like a new workbook for each
of EEP, CHKN, LFAN, MICO and MKA. Not the null values. I each workbook I
would like only the rows where the value (as in EEP or MICO) is present but
all the columns. This may be 30 rows or it may be 1000+ rows.

I have no idea where to start on this one. Any help would be greatly
appreciated!

Thanks.
/Sune

Hi Sune

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

Post back if you need more help

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


"Sune Fibaek" <SuneFibaek@discussions.microsoft.com> wrote in message news:BB40433A-51E8-4AF7-9267-4F18F58F625D@microsoft.com...
> Hi
>
> I have a workbook with something like 25000 rows and 40 columns. I would
> like to split this into about 45 seperate workbooks based on values in
> certain rows.
>
> Example: K2:K25000 contains the values null, EEP, CHKN and LFAN. O2:O25000
> contains the values null, MICO and MKA. I would like a new workbook for each
> of EEP, CHKN, LFAN, MICO and MKA. Not the null values. I each workbook I
> would like only the rows where the value (as in EEP or MICO) is present but
> all the columns. This may be 30 rows or it may be 1000+ rows.
>
> I have no idea where to start on this one. Any help would be greatly
> appreciated!
>
> Thanks.
> /Sune

On Mon, 10 Oct 2005 14:05:01 -0700, "Sune Fibaek"
<SuneFibaek@discussions.microsoft.com> wrote:

>Hi
>
>I have a workbook with something like 25000 rows and 40 columns. I would
>like to split this into about 45 seperate workbooks based on values in
>certain rows.
>
>Example: K2:K25000 contains the values null, EEP, CHKN and LFAN. O2:O25000
>contains the values null, MICO and MKA. I would like a new workbook for each
>of EEP, CHKN, LFAN, MICO and MKA. Not the null values. I each workbook I
>would like only the rows where the value (as in EEP or MICO) is present but
>all the columns. This may be 30 rows or it may be 1000+ rows.
>
>I have no idea where to start on this one. Any help would be greatly
>appreciated!

This thread should help you get started.

http://groups.google.com/groups?as_q...=2005&safe=off

or

http://tinyurl.com/aqg55

Thank you!

It seems to be what I'm looking for. I'll have to look into it tomorrow. I
might beback for more advice!

/Sune

"Ron de Bruin" wrote:

> Hi Sune
>
> Try this
> http://www.rondebruin.nl/copy5.htm
>
> Post back if you need more help
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
> "Sune Fibaek" <SuneFibaek@discussions.microsoft.com> wrote in message news:BB40433A-51E8-4AF7-9267-4F18F58F625D@microsoft.com...
> > Hi
> >
> > I have a workbook with something like 25000 rows and 40 columns. I would
> > like to split this into about 45 seperate workbooks based on values in
> > certain rows.
> >
> > Example: K2:K25000 contains the values null, EEP, CHKN and LFAN. O2:O25000
> > contains the values null, MICO and MKA. I would like a new workbook for each
> > of EEP, CHKN, LFAN, MICO and MKA. Not the null values. I each workbook I
> > would like only the rows where the value (as in EEP or MICO) is present but
> > all the columns. This may be 30 rows or it may be 1000+ rows.
> >
> > I have no idea where to start on this one. Any help would be greatly
> > appreciated!
> >
> > Thanks.
> > /Sune
>
>
>

John,

Thanks. I couldn't quite get i to work, but I'm looking into it tomorrow.

Thanks for your input.

/Sune

"John" wrote:

> On Mon, 10 Oct 2005 14:05:01 -0700, "Sune Fibaek"
> <SuneFibaek@discussions.microsoft.com> wrote:
>
> >Hi
> >
> >I have a workbook with something like 25000 rows and 40 columns. I would
> >like to split this into about 45 seperate workbooks based on values in
> >certain rows.
> >
> >Example: K2:K25000 contains the values null, EEP, CHKN and LFAN. O2:O25000
> >contains the values null, MICO and MKA. I would like a new workbook for each
> >of EEP, CHKN, LFAN, MICO and MKA. Not the null values. I each workbook I
> >would like only the rows where the value (as in EEP or MICO) is present but
> >all the columns. This may be 30 rows or it may be 1000+ rows.
> >
> >I have no idea where to start on this one. Any help would be greatly
> >appreciated!
>
> This thread should help you get started.
>
> http://groups.google.com/groups?as_q...=2005&safe=off
>
> or
>
> http://tinyurl.com/aqg55
>
>
>