How do you Pull Data from another Excel Document that is being auto generated daily

[Bryan.Pagenkopf]

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!

[1aaaaaaaaaaaaaaa]

Are you looking to accomplish this with or without VBA code?

[Bryan.Pagenkopf]

Whichever is the cleanest option. I'm assuming that it would have to be with a Code to work at all because the Reference File would constantly change names or be deleted and replaced daily.

[Bryan.Pagenkopf]

I have macro but I can't get it to function right.

It is supposed to be performing the find and replace action within Columns A:E. Looping through the string values located within L67: R67 and replacing it with the string value in cell K67.

Please Login or Register  to view this content.

Any Help would be appreciated!

[Bryan.Pagenkopf]

Thank you to FLUFF13!

Please Login or Register  to view this content.