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.

	A	B	C	D	E
1	info	info	info	info	info
2	(added row) new info	new info	new info	new info	new info
3
4	Text	text	text
5	constant 1	a1+b1*a5	a1+c1*a5
6	constant 2	a1+d1*a6	a1+e1*a6
7
8	duplicated area:
9	duplicated Text	duplicated Text	duplicated Text
10	duplicated constant 1	a2+b2*a10	a2+c2*a10
11	duplicated constant 2	a2+d2*a11	a1+e1*a11

<tbody>
</tbody>

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