L
Legacy 450108
Guest
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
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