A Masterfile to summarize multiple workbooks

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

Alex, this sounds very similar to what I needed to do recently.

The code below will
- open all the excel files in a specified folder,
- extract the specified data to a new row in a new workbook.

The original source code is from: https://msdn.microsoft.com/en-us/lib...ice.14%29.aspx

The code has been modified to allow the end-user to specify the file folder location in cell B5 of the macro-containing Summary Generator file. Thanks to users Spitfireblue and Bakerman2 for their input in this post: http://www.excelforum.com/showthread...8928&p=4384578

Let me know if this is what you were trying to do.

Jonny

Please Login or Register  to view this content.

Wow, thanks a lot Jonny (and Spitfireblue and Bakerman2 for support with OC)! I will have a go with it and see where it get's me.

Best,
Alex