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