Leonardo1234
Member
vba is placed in different files
all files are located in same path
files are not opened
if column B of sample.xls matches with column C of sample.csv and column J of sample.csv contains ABC and column L of sample.csv is empty then add 0.05 to column E of sample.xls and paste the total amount to coulmn L of sample.csv
And
if column B of sample.xls matches with column C of sample.csv and column J of sample.csv contains XYZ and column L of sample.csv is empty then subtract 0.05 to column F of sample.xls and paste the total amount to coulmn L of sample.csv
all this i have to do by vba so plz have a look and do needful
save and close all the files
all files are located in same path
files are not opened
if column B of sample.xls matches with column C of sample.csv and column J of sample.csv contains ABC and column L of sample.csv is empty then add 0.05 to column E of sample.xls and paste the total amount to coulmn L of sample.csv
And
if column B of sample.xls matches with column C of sample.csv and column J of sample.csv contains XYZ and column L of sample.csv is empty then subtract 0.05 to column F of sample.xls and paste the total amount to coulmn L of sample.csv
all this i have to do by vba so plz have a look and do needful
save and close all the files