[FONT="]vba is placed in different files[/FONT]
[FONT="]all files are located in same path[/FONT]
[FONT="]files are not opened[/FONT]
[FONT="]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[/FONT]
[FONT="]And[/FONT]
[FONT="]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[/FONT]
[FONT="]all this i have to do by vba so plz have a look and do needful[/FONT]
[FONT="]save and close all the files
[/FONT][FONT="]<article class="message-body js-selectToQuote" style="box-sizing: border-box; margin: 10px 0px 0px;">sample.xls is 1.xls
sample.csv is BasketOrder..csv
ABC is BUY
XYZ is SELL
all files are located in desktop
vba code will be placed in seperate file
Download sample files from the below link
https://chandoo.org/forum/attachments/basketorder-csv.60506/
https://chandoo.org/forum/attachments/1-xls.60501/
</article>[/FONT]
[FONT="]all files are located in same path[/FONT]
[FONT="]files are not opened[/FONT]
[FONT="]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[/FONT]
[FONT="]And[/FONT]
[FONT="]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[/FONT]
[FONT="]all this i have to do by vba so plz have a look and do needful[/FONT]
[FONT="]save and close all the files
[/FONT][FONT="]<article class="message-body js-selectToQuote" style="box-sizing: border-box; margin: 10px 0px 0px;">sample.xls is 1.xls
sample.csv is BasketOrder..csv
ABC is BUY
XYZ is SELL
all files are located in desktop
vba code will be placed in seperate file
Download sample files from the below link
https://chandoo.org/forum/attachments/basketorder-csv.60506/
https://chandoo.org/forum/attachments/1-xls.60501/
</article>[/FONT]