Macro to copy files in specific directories

[howard]

I download several csv files each month and then import these into excel. These files reside in a directory called "CSPAYPAC"


I would like a macro to copy these files as follows into the following directories before importing these



1) The files starting with an E eg EDTXRCM.csv must be copied into directory East
2) The files starting with an N eg NETXCRM.csv must be copied into directory North
3) The files starting with an R eg RMTXCRM.csv must be copied into directory Rand
4) The files starting with D eg DMTXCRM.csv must be copied into directory Deep


Your assistance in this regard is most appreciated

 

[dulitul]

are these single files or you want to copy all files starting with E,n,R etc. from this directory?

 

[howard]

Thanks for the reply

Under directory CSPAYPAC, one could have multiple files start with an E, N, R Etc that needs to be copied into the repective folder