Copy data to a different folder

Closed
Posts
2
Registration date
Monday November 9, 2015
Status
Member
Last seen
November 9, 2015
-
Hi All.. i need a macro to copy data from one sheet to another in a different workbook and folder.

There are 2 folders which contains files of same name in them.

I need a macro to find the files of same name and copy the data in the 1st sheet of that file in source folder to the 2nd sheet of the file of same name in the destination folder.

Can anyone please help me on this.

Thanks in advance