Hello,
I'm working on a project where I'm creating a dashboard for a 12 week rolling schedule. I pull the data from 12 individual workbooks that automatically get updated each day. However, if i were to utilize the data in its current state, then it would only be accurate for 1 week, and then I'd have to link a new week in. Is there a way that I can use indirect or a similar vba code to automatically search for a new file, and when it's created, pull it into my master dashboard?
I'm working on a project where I'm creating a dashboard for a 12 week rolling schedule. I pull the data from 12 individual workbooks that automatically get updated each day. However, if i were to utilize the data in its current state, then it would only be accurate for 1 week, and then I'd have to link a new week in. Is there a way that I can use indirect or a similar vba code to automatically search for a new file, and when it's created, pull it into my master dashboard?