Getting data from all files in a directory

[xcellbeginner]

I am trying to automate getting data from every file within a folder into a master report file and looking for some direction. Every file is setup identical for data structure and formatting. Every file has two tabs (Accounts & Scorecards).

Trying for:

1.) In the Accounts tab or sheet
2.) Unfilter row 1
3.) Starting in row 2 until the end of the data
4.) if column k has data (isn't empty) and the corresponding column L is empty then copy the data (column b, column I, and workbook name)
5.) with the master report sheet in column a (workbook name that was copied), column b (column b that was copied), column c (column I that was copied)
6.) go through each file in directory and put each record that meets criteria in 4.) in the master sheet
7.) add the filter back to the original sheet

I have attached an example workbook in which the data from row 3 and row 4 would be copied to a master file.

Thank you for any help!

[RudiS]

Hi,

Thanks for those clear instructions...
Just one question. What is the original filter that must be re-initialized?

[RudiS]

Try this template called "Master" which contains a trigger button.
The macro will prompt you to select the files in the folder. (Highlight them all and choose OK)
The rest will be automatically processed....

Attached...

[xcellbeginner]

Thank you Rudi! I won't get a chance to look at until tonight. I forgot to filter when creating the test file 1 but the filter is row 1.

Thank you again and I will provide feedback once looking at!!

[Leith Ross]

@ xcellbeginner, RudiS

Please refrain from using Private Messages for sharing information about a post. Everyone is left in the dark about what is happening.