Copying/moving files to a pre-exsiting sub-folder based upon column attribute

Hello all,

Column A contains a file name (not full path, just name "1318720900.tif)
Column B contains the name one of five counties associated with the file (County-A, County-B, etc.)

All files from column A are in the same folder (Ex. C:\myTIFFS)
Named folders to be sorted into already exist as subfolders (Ex. C:\myTIFFS\County-A\, C:\myTIFFS\County-B\, etc.)

How can I get Excel to sift through row by row and sort the files into folders based upon their Column B value?

I appreciate any help!

Take care,
Jeremiah

The easiest way is to put this macro into a workbook, and save the workbook in the same folder as the files named in column A:

Please Login or Register  to view this content.