copy paste

[yoyomail]

[FONT=&quot]vba is placed in different files[/FONT]
[FONT=&quot]all files are located in same path[/FONT]
[FONT=&quot]files are not opened[/FONT]
[FONT=&quot]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=&quot]And[/FONT]
[FONT=&quot]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=&quot]all this i have to do by vba so plz have a look and do needful[/FONT]
[FONT=&quot]save and close all the files
[/FONT][FONT=&quot]<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]

 

[mole999]

whose project is this ?

 

[alansidman]

crosspost at: https://chandoo.org/forum/threads/copy-paste-of-data.41852/

 

[yoyomail]

it is my project sir
and sorry for the same