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
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