Hi,

As part of my work, I receive reports on a daily basis with various data.
All daily Excel documents are named in the same way (today's date) and stored in the same place.

I now want to build a Master document that automatically reads the data from the daily reports once opened.
My approach was to have the actual date on column A, convert it to text on column B, specify location in column C using the below line:
='\\cpmpanyname\private$\location-x\...\my-reports\[B1]Financials'!$H$4

This approach isn't really working as it launches a Window and asks me to confirm the location and file.

Any help would be highly appreciated!

Cheers
Spyros