If column E of target1.xlsx matches with column A of target2.xlsx then copy column Y of target1.xlsx and paste it to target2.xlsx from column C(if column C has data then paste the data in column D and if column D also has data then in column E and so on....)
vba will be placed in a seperate file
vba will be placed in a seperate file