Extract rows matching condition

[Costin Gusa]

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

 

[Ron de Bruin]

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