I know I may violating a cardinal rule of Stack overflow by not providing any code but I am completely lost. I need a link between two workbooks, which is easy. The issue is that the workbook I am using for the data source is irregularly downloaded, up to 10 times a day, from another program and stored in a folder that has hundreds of files, all with the same name just a time stamp added to then end. I need the link to look for the latest download and use that file. I can't find anything on the MS page or the web on how to right this. To add to it I would like to use only formula if possible but can switch to VBA if required. Please, can anyone at least point me in the right direction?
0 Answers
Related