Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extract rows matching condition
Hello,
I have some .xls files in a folder (many enough - 200 - to start thinking about scripting) each containing one sheet named "sheet1" I'd like to extract from each .xls file the entire rows that match the following condition: ("row number is greater than 20" AND "column B does not contain any value") and add those matching rows into a new big .xls file Altough I believe this can be easily scripted by a heavy-experienced scripting guy, my excel scripting history is null, but I think I could make a start from some examples Thank you very much, Costin |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extract rows matching condition
Hi Costin
I have a example here that use Autofilter Try this first and post back if you have the example working. http://www.rondebruin.nl/copy3.htm See this example http://www.rondebruin.nl/copy3.htm#Filter We can change the example then to your situation if you need more help then -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Costin Gusa" wrote in message oups.com... Hello, I have some .xls files in a folder (many enough - 200 - to start thinking about scripting) each containing one sheet named "sheet1" I'd like to extract from each .xls file the entire rows that match the following condition: ("row number is greater than 20" AND "column B does not contain any value") and add those matching rows into a new big .xls file Altough I believe this can be easily scripted by a heavy-experienced scripting guy, my excel scripting history is null, but I think I could make a start from some examples Thank you very much, Costin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use extract into a condition | Excel Worksheet Functions | |||
search for data matching some condition | Excel Worksheet Functions | |||
extract matching vales | Excel Discussion (Misc queries) | |||
Using condition to extract data by matching values from 2 different Excel files | Excel Programming | |||
Extract only non-matching data | Excel Programming |