- Feb 25, 2019
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!