Hi All,

Every morning at work I download a what's in stock report from SAP. I save all of the reports in 1 folder and save them with the current date (xx.xx.xxxx Stock) daily.

Once I have this I do a vlookup in another file every morning to get stock for specific skus.
I am wondering if there is any way I can automate this?
So for example maybe have a button in the other file that just automatically refreshes the data from the latest file I download and never have to do vlookup again.
I hope this makes sense.

Thanks!