• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel Automate Copy Paste based on rule

Status
Not open for further replies.
S

shiva93

New Member
I hope you are doing well.
I would like to know code available to automate my process to copy one file to another in excel using VBA from two different folder

First folder contains excel (.CSV) file with name 01-04-2022_Day.csv, 01-04-2022_Night.csv, 02-04-2022_Day.csv, 02-04-2022_Night.csv, & so on

Second folder contains file excel(.xlxs) with 01-04-2022_DS.xlxs, 01-04-2022_NS.xlxs, 02-04-2022_DS.xlxs, 02-04-2022_NS.xlxs and so on.

I want to copy data from

01-04-2022_Day.csv ( c column) to 01-04-2022_DS.xlxs (w column),

01-04-2022_Night.csv ( c column) to 01-04-2022_NS.xlxs (w column),

Process continues for each date

I would be happy to hear from you

Thanks & Regards Shiv
 
A must read : How to get the Best Results at Chandoo.org​

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...
chandoo.org
 
Status
Not open for further replies.
Back
Top