Loop Through All Files, filter data and Copy Data to Summary Workbook to the next available row VBA

[v3105bp]

Appreciate if someone can help me with the code. I have a folder with several files in it. What i would do is select that folder> open all files and filter for "equity" criteria then copy and paste to master workbook and do the same to all files in that folder. If no "equity" filter then move on to the next file and so on. Is there a way to loop , filter , copy and paste to master workbook and copy again to the next available row?

 

[John_w]

You could record a macro to do the steps for one of the files and edit the code to add a Dir function loop, plus some other tweaks to find the next available row, however the easiest method is with Power Query and then no VBA code is needed. Get started with Data tab -> Get Data -> From File -> From Folder.