Copy files to a new folder using VBA

[imaguy77]

Hi all,

I have a VBA question for you all which would be hugely helpful if i could get working:

I have 2 columns: Column A has a new folder name that I'd like created
Column B has the first 6 characters of a filename.

I want to look in the main folder for files matching column B, and copy all files matching column B to the folder specified in column A as a subfolder of the main folder.

For example, column A would have 12 rows, 6 with Retail and 6 with Supply Chain. Column B would have 12 records each like D600666, D900999, etc. which specify departments.

Does this make sense? Any help is much appreciated!!


-Jeff

 

[imaguy77]

Any ideas??