Hello Excel Experts,

I am looking for a VBA code that copy particular data from my source files to my destination file base on below rules.

I have different files with date format name (exm. 01-Jan-2018, 02-Jan-2018 and so on)

My destination file first column has same dates and need data from source file matching with destination file date and copy into next columns.

Or if anyone has better solution than also work, My aim is to copy all required data into one common file.

please let me know the VBA code that will help me to do this.

Thanks
Mandeep Takawane