copy paste by vba

[Legacy 450108]

If column E matches with column C and column M has a blank cell then ignore that


If column E of sample1.xls matches with column C of sample2.csv and column M of sample1.xls contains (-) minus sign example(-1.00,-2.00 etc) then see column O of sample1.xls and calculate the 1% of column O of sample1.xls and add the 1% of column O of sample1.xls with itself and paste the result to column L of sample2.csv


Or


If column E of sample1.xls matches with column C of sample2.csv and column M of sample1.xls doesnt contains (-) minus sign example(1.00,2.00 etc) then see column P of sample1.xls calculate the 1% of column P of sample1.xls and subtract 1% of column P of sample1.xls with itself and paste the result to column L of sample2.csv
save and colse all the workbooks
i have to do the same by vba
sample1.xls contains headers in the first row so ignore first row
sample2.csv doesnt contains any headers
vba is placed in a seperate file
all files are located in same place
only 1 file is opened vba code placed file so we have to open the the sample1.xls file and sample2.csv file and then we have to do the process

 

[Legacy 450108]

Sir plz reheck the code sir it contains error

 

[Legacy 450108]

This problem isn't solved plz relook into the code Sir and Mam and plz guide me to make this code workable
i tried editing some part of the code but the problem was not solved so plz guide

 

[Legacy 450108]

Thnx Alot Sir for giving ur precious time and great support to this post
Problem Solved
Code contains small errors and it has been resolved
Thnx Alot