Insert Row in other sheets with inserted formula. 2007

Good day everyone,
Been looking for this info but not to my finding… If someone could give me a hand it would be appreciated.
In my Sheet1(“Rapport”) I have information in my Column A from 5 to 20 (Titles).
In my sheet2,3,4,5 (No Name just Sheet2,3,4,5) I have the same information. My Formulas is =Rapport!A5 and so on till =Rapport!A20.
So my 4 sheets = to my Sheet1(“Rapport”)
I need that when I insert a new row on Sheet1(“Rapport”) to insert the same Insert Row in all other sheets but to also add the formula.

I tried to record a macro and the code is the following:

Please Login or Register  to view this content.

But now it to add the ActiveCell.FormulaR1C1 = "=Rapport!RC" In all the sheets(2,3,4,5) in that new inserted row.

Please Help

Test Stats 2011-2012.xls

Now the Formula wont add up I need everything to shift Down...

Found my answer, I used a code I had in another workbook...

Please Login or Register  to view this content.