[VBA] Creating sheets based on criteria

[Guest]

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

 

[Ron de Bruin]

Hi Sune

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

Post back if you need more help

 

[John]

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_...5&as_maxd=10&as_maxm=10&as_maxy=2005&safe=off

or

http://tinyurl.com/aqg55

 

[Guest]

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

 

[Guest]

John,

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

Thanks for your input.

/Sune