Apologies if this has been asked before but I’m not sure how to word a search for this problem!
I’m trying to create a summary document for a directory of files. The idea is that you can type in the unique id for a file you’re looking for, and it will automatically return the information inside.
I can achieve this by linking to the cell in the relevant file, but this will be too complicated for my team so I want it to link just by matching the unique id in the filename.
I’ve tried various soltuions with VBA, MS Query, and hyperlinks and vlookups, but I’m a novice with excel and it’s not working. Any ideas?