Instead of referring to cells in formula by cell name you should refer to by in a relative manner . Instead of entering b2=c2*c1 . You should enter b2= c@row*c@(row-1).