Automatically copy formula when adding row

[sarmadamidi]

Dear all,

After greetings...

I will appreciate if you tell me how to copy formula automatically when adding row?


kindly see the attachment

thank you

[Special-K]

If the row you are adding lies within the range the formula references then the formula will update itself.
If this is not the the answer you require then you need to provide more info.

[sarmadamidi]

thank you my dear for your answer, kindly see the attachment

[sarmadamidi]

please help me guys

[newdoverman]

Change the range D2:H6 to a DATA TABLE from the Insert tab, Insert Table.
All you have to do is to select the range D2:H2 and insert table. Make sure that you have checked "My Table Has Headers". Delete all unused rows except the first row, enter the formulae that you want for the table and every time you add a new row, the formulae will be properly copied to the new rows.

I enclose your sample workbook with both ranges converted to tables.

[sarmadamidi]

Thank you so much my dear, this is exactly what i want

[newdoverman]

Thank you for the feedback.