Subject: Pulling Data from another Workbook

[DarbyBrown]

I have 2 excel workbooks, “Main”, and “Counter”. I need to pull data from a cell from a sheet in “Counter” and enter it into a cell in workbook “Main”.

Workbook “Main” is recreated from a Template each month and renamed “[this Month],[This Year] ie: “Jun22 “. There is a cell in Main that contains the Start date of that workbook. (“06/01/22”)

Within Workbook “Counter” there are 12 Sheets, 1 for each month.

I need to pull the data from the Total cell in the “Counter” sheet for the appropriate month of the Workbook “Main” that I am working in and put that data in the appropriate cell in “Main”

I know how to pull data from another worksheet by including the ‘Jun22” in the formula ‘(=[Counter.xlxs]Sheet6!B12)’ for Jun22 sheet, but need to change that formula every time I create a new “Main” Workbook from the Template

I am hoping that there is a way to create a formula, in the Template, that will use the start date in the “Main” workbook and find the correct sheet in “Counter” from which to pull the correct data.

 

[GlennUK]

Why don't you have a summary sheet in Counter that collates all the months into a list, a total per month, and then you lookup into that list?