Inserting rows and having the formula follow
 

I have the formula =SUM(I2:I190/F2:F190) which works wonderfully. Only
problem is that when I go to insert a new row, the formula won't follow down
that column without draggin it from the cell above... any way to do this
automatically?
Thanks in Advance!

With a macro

http://www.mvps.org/dmcritchie/excel/insrtrow.htm


Regards,

Peo Sjoblom

"workofiction" wrote:

I have the formula =SUM(I2:I190/F2:F190) which works wonderfully. Only
problem is that when I go to insert a new row, the formula won't follow down
that column without draggin it from the cell above... any way to do this
automatically?
Thanks in Advance!