Conditionally copy & paste the data with matching

Hi,
I am looking for a Vba Macro
Conditions:
Hardcode the Path of the file so that i can change it as per my needs

macro will be placed in master.xlsm
I have two files named as 1.xls & 2.xls
i am looking for a macro that will match column A each cell data of 2.xls with column A each cell data of 1.xls & if it matches then it will copy column C data of 2.xls & column D data of 2.xls in & paste it to column D & column E of 1.xls
& if it doesn't matches then do nothing

Plz see the output sheet in 1.xls only for reference(there will be no output sheet in 1.xls , I have only created output sheeet only for understanding purpose)

Thnx For The Great Help

If I understand you correctly, maybe :

Please Login or Register  to view this content.

To test the sub :
Copy your 1.xls and 2.xls to a test folder. For example in drive D:\test
Create new workbook, name it Macro.xlsm then put the sub above in VBA module.

In your Macro.xlsm active sheet, fill:
cell A2 with D:\test\
cell B2 with 1.xls
cell C2 with Sheet1
cell A3 with D:\test\
cell B3 with 2.xls
cell C3 with 1-Sheet1
cell D3 with A1:F1000

something like this :
EXCEL_2022-06-21_20-26-42.png

Make sure that the data in 1.xls and 2.xls is the same with the one you attached in your post.
Make sure that 1.xls and 2.xls are not open, then run the macro.

It will open 1.xls and it directly fill column D and E in sheet1 with vlookup formula looking to 2.xls 1-Sheet1 range A1:F1000

Thnx for the Great Help
Working Perfect