Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
[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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
[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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
[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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
[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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum sheets based on criteria | Excel Worksheet Functions | |||
Min/Max based on criteria (2 sheets) | Excel Worksheet Functions | |||
CREATING FORMULA IN ONE WORKSHEET BASED ON MULTIPLE CRITERIA IN AN | Excel Worksheet Functions | |||
Creating function to insert data based on criteria | Excel Worksheet Functions | |||
creating new sheets based on specific data | Excel Programming |