Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|