L

#### Legacy 450108

##### Guest

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