Deleting/Adding Rows without affecting formula

[Mykazi]

I have the following formula in column J (formula could be better I know):
=IF(I35<>"EOM",IF(D35>0,J34,J34+G35+(H35/1507.5)-F35-E35),J34)

1) From time to time, I need to delete a row. When I do so now, obviously it gives me #REF in all cells of column J beneath the deleted row. How can I fix this by having all cells beneath the deleted row automatically reference itself to the new above cell.

2) Also, when adding a new row, can I have the formula in column J automatically appear in that new cell?

Thank you. (How do you upload images here?? It would have made this so much easier)

 

[Special-K99]

You need to upload file to a net storage area then provide a link to the file.
Better to post (dummy) spreadsheets than images otherwise we have to enter your data all over again to test.

 

[Mykazi]

https://dl.dropboxusercontent.com/u/38600242/Example.xlsx