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