I would need to see the formulas (not the results) in order to give a precise response.

As it is, all I can tell you is ... this will insert a row based on row number "n":
Rows(n).Insert Shift:=xlDown
The formulas will shift automatically if you have used relative row references throughout. If not, you will need to re-write the formulas for all rows below "n".