Hey Folks,

I have an AutoHotKey script running everyday that downloads a CSV file from a website. The naming convention is based on the current date 081313.csv, 081413.csv, 081513.csv etc. I have no problems setting up an INDEX/MATCH to grab the info I need from it, but I can't input the formula of a file that isn't created yet so I am stuck editing the formula everyday to reflect the most up to date values. I have the dates listed at the top so I was trying to setup an INDIRECT with no luck as well.

I have attached a file that hopefully explains what I am talking about.

Thanks!

Project File.xlsx