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 |
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 |