Tough Challenge: Can you automatically select only the files in a directory whose filenames appear in a spreadsheet?
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.
This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.