Copy Data from one excel workbook to another if name workbook matches

[kshivanand21]

Hey guys, I hope you all doing well.

I wanted to create macro for the following case, i have multiple workbook in one folder following as 1.01.2021 Day & 1.01.2021 Night to 31.01.2021 Day 31.01.2021 & another folder containing workbook named as 1.01.2021 DS & 1.01.2021 NS. Now I want to create macro to copy data from 1.01.2021 Day to 1.01.2021 DS & 1.01.2021 Night to 1.01.2021 NS respectively. Follow the same rule for rest of dates.

Thanks & Regards

 

[gordsky]

are the DS & NS workbooks blank before the data is copied to them and are you copying the entire contents of Day & Night over to them

 

[kshivanand21]

DS & ns workbook has data, i am copying entire one column from day & night to ds & ns workbook. Thanks mate for reply.