Copying a specific area in Excel when adding a new line above that area

[MRDBS]

Hi guys

I am wondering if there is a possibility to automatically duplicate a specific area within an Excel sheet.
In this case when I add a new line above the specific area.

This line will contain infos which should be added/used in the duplicated area/layout.
The area contains constance and formulas based on the row added.

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]info[/TD]
[TD]info[/TD]
[TD]info[/TD]
[TD]info[/TD]
[TD]info[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD](added row) new info
[/TD]
[TD]new info[/TD]
[TD]new info[/TD]
[TD]new info[/TD]
[TD]new info[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Text[/TD]
[TD]text[/TD]
[TD]text[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]constant 1[/TD]
[TD]a1+b1*a5[/TD]
[TD]a1+c1*a5[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]constant 2[/TD]
[TD]a1+d1*a6[/TD]
[TD]a1+e1*a6[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]duplicated area:[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]duplicated Text[/TD]
[TD]duplicated Text[/TD]
[TD]duplicated Text
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]duplicated constant 1[/TD]
[TD]a2+b2*a10[/TD]
[TD]a2+c2*a10[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]duplicated constant 2[/TD]
[TD]a2+d2*a11[/TD]
[TD]a1+e1*a11[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

The red part I would like to autogenerate, based on the new info provided in row 2.

I hope this explains what I am trying to attempt

Thanks for your help.
Regards MrDBS

 

[MRDBS]

Bump.... No one any idea? I was thinking maybe with a macro? I just don't know how. I am totally new to the whole macro business