VBA code to copy multiple files to a new folder; based on corresponding cell value

[jimmy7868796]

I've spent all my day off trying this! Complete VBA noob so not surprising. My below code (I appropriated from someone else) works perfectly fine for transferring one file - however, I need multiple files!

For example, my column H in worksheet 'Bat' has 200 cells with file names which correspond to files within folder X. I need them moved to folder Z.

Any help much appreciated

code below...

Please Login or Register  to view this content.