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?
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?