Is it possible to automatically clone rows when creating new rows in another table.

[MRDBS]

Hei guys

I have a nut I am just not able to crack.

I have two tables.
Both tables are similar.
One for input and output.
One for calculation.

I did this to protect my formulas, I know I know....

So my question is: Can I create a rule to add a line with formulas in my calc. table, when I copy/add a line in my input table?

So to say I create a new line for inputs, (insert copied fields) and then automatically create a new row to calculate the output.

Alternatively can I add a field in my Form which determines the amount of rows I would need?

Edit:

Example:

Table 1

Table 2

ALTERNATIVE 2 would be to add a field that auto creates as many rows as requested like, let's say we enter 2 in cell Z2

That then creates 2rows in table1 and two corresponding rows in table2

 

[MRDBS]

One suggestion in r/excel was:

=OFFSET(Sheet1!$A$3;0;0;COUNTA(Sheet1!$A3:$A1048576);COUNTA(Sheet1!$3:$3))

Which i did not get to work.