Auto copy formula after row insert

[michibahn]

Hi,

I'm working on a spreadsheet wherein I need to auto copy the formula from the above cell to the new cell below which is technically a new row.

Attached is a snapshot on what I have in excel using the formula =SUM(A1,-B1) in the 1st row then on the 2nd row -- and so on.. =SUM(C1,A2,-B2) to calculate the BALANCE column

values in QTY IN and QTY OUT are automatically populated when I run my script. I just want the BALANCE column to calculate automatically also.

TIA!

 

[rdw72777]

I'm confused, how is the new row getting created. if you're just inserting a row below the last row, I don't see why copying down the formula wouldn't work. it looks like it would work to me.

 

[michibahn]

I'm confused, how is the new row getting created. if you're just inserting a row below the last row, I don't see why copying down the formula wouldn't work. it looks like it would work to me.

hi rdw, sorry for the confusion. the new row is inserted from an external data which is an MS Access query.The new row is inserted based on its ID which is another column before QTY IN (I didn't show in my snapshot) So basically, the new row will be inserted randomly anywhere in my table.

If the new row is inserted in the last row of the table, the formula is copied. However, if it was inserted in the middle or anywhere except the last row, the formula is not copied.

thanks!

 

[michibahn]

hope someone can help me on this. thanks!

 

[michibahn]

hi rdw, sorry for the confusion. the new row is inserted from an external data which is an MS Access query.The new row is inserted based on its ID which is another column before QTY IN (I didn't show in my snapshot) So basically, the new row will be inserted randomly anywhere in my table.

I just want the formula to be autmatically copied after inserting a new row.

thanks!

corrected my reply..