VBA Code for Copying data from different files to Destination file

[mtakawane]

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

[Doc.AElstein]

Hi Mandeep,
It sounds like what you want is possible
But I think it would be very difficult to give you a working solution based on the limited information that you have given us.

It would be helpful to have
a
Before
and
After

The Before could be one of your source files , but preferably with the amount of data in it reduced to the minimum necessary, and also desensitised if necessary to remove personal or sensitive information

The After would be something such as a worksheet which you fill in manually to show what it is that you want the code to do. In other words, for a reduced sample data you do manually with that data what you want a code to do for you on the full data.

Alan