Hello, I have a graph that needs to be updated daily.
The data comes from an auto-generated excel report that has the same name but with the date changed.
myreport 10-01-2018.xls
myreport 10-02-2018.xls
myreport 10-03-2018.xls
Each time it generates it provides the current previous days number as well as the numbers from the previous days in the current Month.
Is there a way to link the reference excel doc to my Excel doc even though it does not exist yet/as they come into existance???
Any advice is welcome here!
Thank you!
Bookmarks