[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

[VBA] Creating sheets based on criteria
 

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" wrote in message ...
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

[VBA] Creating sheets based on criteria
 

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" wrote in message ...
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

[VBA] Creating sheets based on criteria
 

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"
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...005&safe=o ff

or

http://tinyurl.com/aqg55