Moving files with certain filename qualities to folders

Good morning!

Please note that I’m quite new to VBA in terms of serious projects. Basically I’m just trying to figure out if a project on which I want to work is even possible and, if so, what the best way to go about it would be:
I have a folder full of .xls files which need to be distributed into other folders based on a number/letter string the middle of the filename.

However, the specific folders into which they need to go is determined by a spreadsheet. The spreadsheet doesn’t say where the files need to go but it does say what properties the files have which would determine into which folder they’re being sent (ex: gender, department, etc.)

Is it possible to integrate a macro into the spreadsheet with the properties, find a filename with the correct number string and then send that file to another folder? If so, what’s the best way to go about it?

Many thanks!

Originally Posted by davegugg

Could you provide a sample list of filenames and the folders you want them put into?

Certainly!

The file name generally looks like: “Qualifier ABC Date.xls” where “ABC” is the string that I’d want my macro to hunt. You can then imagine a folder with 100+ files with different string permutations: that’s what I’m trying to get sorted into folders.

The data itself looks something like this:

ABC Date Male
DEF Date Female
GHI Date Male
JKL Date Female
MNO Date Male
PQR Date Female

So, what I’m trying to tell my macro is: For each letter string, find the file in folder “X” and then put it into either folder “Male” or folder “Female.”

Does that help explain what I’m trying to accomplish?