Insert rows with formulas based on a cell value

[Heguli]

Hey,

Please I need help in this case; thank you in advance!

I insert data and have the data in Table1 in Sheet1:

A1 DATA	B1 Order	=COUNTA(A2;A1000) (result: 2)
A2 Car 1	B2 25
A3 Car 2	B3 45

<tbody>
</tbody>

Every time I insert new data, new data might add/cut rows to/from this table. I count the amount of rows with COUNTA -> this scenario I have 2 rows.

I have another Table2 in Sheet2, which is linked to Table1 above.

Car 1	Car 2
=formula1 linked to table above​	=formula2 linked to table above
=formula1 linked to table above​	=formula2 linked to table above ​

<tbody> </tbody>

<strike></strike>
I would like to be able to just insert the automatic SAP data to Table1, which adds rows to A and B column. I calculate the amount of rows with COUNTA.
I would like Excel to automatically insert as many rows as COUNTA cell gives to this Table2 and automatically copy the formulas to those rows -> this example those formula1 and formula2 rows would be automatically created. Currently I have to manually extend Table2 rows with formulas in order to cover all rows from Table1.

How could be this done with VBA?

Thanks!