Copy data from one to workbook to another

[excelactuary]

Hello,

I need some advice regarding following:

Once a month a workbook is created with reports. The structure of the monthly workbooks looks in 2019 like this:

Statistics Modell 201901.xlsx
Statistics Modell 201902.xlsx
Statistics Modell 201903.xlsx
Statistics Modell 201904.xlsx
Statistics Modell 201905.xlsx
Statistics Modell 201906.xlsx

Every workbook requires data from the workbook of the previous month. This means the following:

„Statistics Modell 201906.xlsx“ requires data from „Statistics Modell 201905.xlsx“
„Statistics Modell 201905.xlsx“ requires data from „Statistics Modell 201904.xlsx“
…and so on…

The layout (sheets, data position in the cells) of the workbooks is identical.

What ist the most elegant way to reference data from one workbook to another? The references are going to stay the same every month.

I want to build a master file which only needs to be copied and renamed and every month. This means, if we look at the future:

„Statistics Modell 201907.xlsx“ should automatically reference to „Statistics Modell 201906.xlsx“

Do you have any idea how to do this?

[Pete_UK]

This might be tricky using formulae, as you will need to use the INDIRECT function to convert a "calculated" reference into an actual reference that Excel can make use of, and the INDIRECT function will only work on external files if they are open in the same instance of Excel.

Can you guarantee that the "previous" file will always be open as well as the "current" file?

An alternative would be to consider dragging the "previous" sheet into the "current" file.

Hope this helps.

Pete

[AliGW]

Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here. I am, therefore, closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-for...o-another.html