Leonardo1234
Member
I have two files opened
1.xls
sample.xlsb
now what i want is copy all the data of coulmn I except I1 of 1.xls bcoz it is a header and paste the data to column D of sample9.xlsx and divide all the data of column D with B3 and paste the result to column E
vba code will be placed in sample.xlsb
and one more thing B3 has formulas and we have to divide the result of the formula with Column D data
1.xls
sample.xlsb
now what i want is copy all the data of coulmn I except I1 of 1.xls bcoz it is a header and paste the data to column D of sample9.xlsx and divide all the data of column D with B3 and paste the result to column E
vba code will be placed in sample.xlsb
and one more thing B3 has formulas and we have to divide the result of the formula with Column D data