Copy filtered data from multiple workbooks in to one

[ipicdesign]

I need to copy data A2:F100000 from 10+ workbooks, sheet1 (all in the same folder called “LC”) into one workbook called “Masterfile” in the sheet called “Data”. However since it is about 100 000 rows of data in each workbook I need to first filter out each row where the value in column E and F are both zero. I’m very new to VBA and was hoping someone could help me out. Thanks!

 

[sandy666]

it must be a vba?

what is your version of excel?

 

[ipicdesign]

Hi, Yes because we need to do this for 10+ workbooks each week so I was hoping vba could handle it.

 

[sandy666]

if you say so

have a nice day

btw. look at PowerQuery