Excel 2010 Formula - adding in a new row and experiencing formatting issues

Hi Everyone,

I am stuck in my spreadsheet and need some assistance. Basically i have a document that is multiple sheets with the first sheet being a summary of all sheets. How i need the sheet to work is as follows, when i enter a new row (above the previous first row or previous row 2):

Row 2 (New row): =Sheetname!B228+Sheetname!D228
Row 3: =Sheetname!B227+Sheetname!D227
Row 4: =Sheetname!B226+Sheetname!D226

BUT

The sheet automatically formats with:

Row 2 (New row): =Sheetname!B226+Sheetname!D226
Row 3: =Sheetname!B227+Sheetname!D227
Row 4: =Sheetname!B228+Sheetname!D228

I need a formula to fix the automatic change to be in actual order so any new rows are calculated in backwards order. Can anybody help please?

Thanks in advance.

self deleted

Unfortunately, the auto increment feature does not work in this instance, so you need to implement it within the formula itself, probably something like this:

Formula:

Please Login or Register  to view this content.

(not tested, but the theory is correct)

Hope this helps

EDIT -
And I am glad I could point you in the right way about the Title rules as well

okay, so the data being looked at is in a different sheet than the data being updated?( I'm guessing that from the use of 'sheetname!range")
then maybe this:

Formula:

Please Login or Register  to view this content.

I obviously have not tested this again, as I have nothing to test against, so the +1 may have to be +2 or may be unnecessary, not truly sure, but I am not going to try to recreate this workbook, sorry

I'm afraid you have completely lost me now...
which sheet gets the inserted row 2?
what is the auto default to d4 for?

Maybe a hand figure before/after for one instance would help, but I'm lost at the moment