Tough Challenge: Can you automatically select only the files in a directory whose filenames appear in a spreadsheet?
Posted on 2013-12-19
Let's say you have a column of file names in a spreadsheet (ie - 12F.jpg, 12G.jpg, 27H.jpg, etc)
You also have a folder full of files. Some of the files match the ones in your spreadsheet (ie - 12F.jpg, 12G.jpg, 27H.jpg). However, some of the files in the folder do not match the ones in your spreadsheet.
Is there an way to automatically select only the jpg files that are in the spreadsheet? That way you can make a copy of only those files for instance.
Thanks so much in advance.