Macros that selects the files according to their names and place them in a separate folder

[Ekaterina26]

Hello,

I have a folder containing 4600 txt. files.
I also have an Excel sheet containing a column with some files from that folder.

I need to select only some files in a separate folder.
Could you please help me create a macros that puts all files indicated in Excel column from the txt.folder into a separate folder?

Thanks a lot!

[dflak]

The attached file will show you how to do it. It uses an Excel table to contain the list of files to copy. I like using tables because they know how many rows and columns they have (you don't have to figure that out in the code) and because you can use the column headers in formulas (no guessing what column X is).

The code also uses a couple of static named ranges for the source and directory names.

[Ekaterina26]

Wow, thank you so much!!
You helped me a lot, I could not imagine doing that manually!