Copy paste and addition by vba

[rider1234]

Vba is placed in a seperate file
open 1.xls files
open PL.xlsx file
all files are located in same path
If column E of 1.xls matches with column A of PL.xlsx and column B of PL.xlsx is blank then copy and paste the column R data of 1.xls to column B of PL.xlsx
Or
If column E of 1.xls matches with column A of PL.xlsx and column B of PL.xlsx has some data (value) then add column R data of 1.xls to column B of PL.xlsx
save the changes made to PL.xlsx
save and close all the workbooks

example
if column B of Pl.xlsx contains -5 and column R of 1.xls contains 4 then in column B of PL.xlsx the data will be -1
if column B of Pl.xlsx contains -5 and column R of 1.xls contains -6 then in column B of PL.xlsx the data will be -11
if column B of Pl.xlsx contains 5 and column R of 1.xls contains -6 then in column B of PL.xlsx the data will be -1

https://files.engineering.com/getfile.aspx?folder=72088320-5968-4cb9-82cc-2dbb25088a48&file=1.xls

https://files.engineering.com/getfile.aspx?folder=1ad25bd2-6112-4a3b-8c2f-aee9e82fdd28&file=PL.xlsx

 

[rider1234]

Thnx Alot Skip Sir for ur great guidance and thnx for the help Sir