I recognize that this is not truly an Excel thing but it's where the data
lives so I would like to continue to use Excel. I have a column that
contains a filename and another column that contains a path. I would like to
either rename all the files that exist in a specific folder OR copy the files
from source path to target path. The data is structured below. The
source/target path can be split if I need to as in drive letter versus a
path, etc...

I would prefer the macro to cascade down one row at a time once the file has
been copied. If the copy command is difficult then I can just have them
renamed and then I can do a manual copy.

Column
A(Filename) B(Source) C(target)
file123.pdf c:\jason u:\archive
file222.txt c:\jason u:\archive