I have added sample files plz have a look
my file name
1.xls
leverage.xlsx
vba code will be placed in a seperate file macro.xlsm
all files are located in same place
code has to open the file and it should do the process and save and close all the file
If column B of 1.xlsx matches with column A of leverage.xlsx then copy column D of leverage.xlsx and paste it to column J of 1.xlsx
sheet name can be anything in both the files