Hi,

I will explain my problem before asking for a solution, as I do not know where to start.

I have a folder structure containing several reconciliation files, all of which have a new name each month (Recs_XYZ_APR-16 for example). I'm now trying to build a summary file which collects data from each reconciliation file.

I assume I need to write a procedure to open each file and return the values I want, or are there other ways to retrieve data from closed files? I tried writing an indexMatch formula to return a value from each file and then a macro to open each file and update the formula.

I apologize for a vague explanation but I not know how to explain this better. Since I don't have the masterfile yet I can unfortunately not attach a file for you guys.

Many thanks for any hints about which direction I should proceed.

Alex