Hi,

I have a list of files in my spreadsheet (column B) with their paths, ie. C:\Temp\test1.txt, C:\Temp\test2.txt and I want to copy them into a destination folder specific to each file (folders are already created) and paths are in column C. Ie. C:\Temp\folder1, C:\Temp\folder2

Is there an easy way to do this in VBA. All I can find is code to copy multiple files in one folder to another specific folder.

Thanks.