I want to calculate the sum of each cell from the first column with the corresponding cell in the second column and put the result in the third column....and so only the end of the column
Example:
code vba:
Range ("J11")=SIERREUR(SOMME(H11:I11)/2;"")
Range ("J12")=SIERREUR(SOMME(H12:I12)/2;"")
Range ("J13")=SIERREUR(SOMME(H13:I13)/2;"")
And in the case that the column cells are empty, it does not put the formula
to the end of the column
Please perform the same task on all colored columns
Example:
code vba:
Range ("J11")=SIERREUR(SOMME(H11:I11)/2;"")
Range ("J12")=SIERREUR(SOMME(H12:I12)/2;"")
Range ("J13")=SIERREUR(SOMME(H13:I13)/2;"")
And in the case that the column cells are empty, it does not put the formula
to the end of the column
Please perform the same task on all colored columns
Dropbox - File Deleted - Simplify your life
www.dropbox.com