selecting a folder and copying all files into another folder

[Holley]

Hello everyone! Hope someone may be able to assist with a project I am working on. I would like to be able to run a macro that will allow me to select a folder and have all the files (they will be .csv) copied into a another folder. The only static address will be the "to" folder. The "from" folder will change each time it is needed.

For example, I would like to move all files in H:\holley\Store\09-05-24\ to H:\holley\Store\Run. It seems like it should be simple, but I'm getting stuck on seleting the initial folder. Any suggestions would be most appreciated! Thank you in advance!

 

[Holley]

This is just an illustration of how you could mass move a folder to another folder. You don’t need the loop.

But you have to change the filepaths to yours.

It is indeed a new macro

AH! I see... almost seems too simple! Thank you!