Help with dynamically pulling data from other workbooks

Dolenhil

New Member
Joined
Mar 4, 2021
Messages
1
Office Version
  1. 365
Platform
  1. Windows
Good evening and thank you in advance for your time and support.

I am creating a daily report that has a date-specific name for example.

01-03-2021 Daily Report
02-03-2021 Daily Report
03-03-2021 Daily Report
04-03-2021 Daily Report

And they are all saved in the same folder.

The idea is that each report pulls data from the same 12 cells of the same column of the previous day's reports, so =today()-1 should then be the variable.
I tried "& or concatenate to break down and put together the address of the other workbooks but nothing is working up to now.
Just to give some heads up I don't want to use indirect as that would mean that the workbooks should be open which I don't want.

Any ideas?
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

Forum statistics

Threads
1,136,304
Messages
5,674,973
Members
419,537
Latest member
ucatchy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top