I need help with automatic generated rows from Jet in Excel.
If i calculate 10 rows in table 2 in Jet and want to automatic copy it to table 1, excel shifts my rows in table 1 exactly with the automatic generated rows in table 2.
For example:
formula (table 2; column A; row 1) automatic generated 10 results.
formula (table 1; column A; row 1 to row 10) = "Table2!$A$1"
After calculation excel shifts these formula in table 1 to = "Table2!$A$11"
How could it be solved?
Thanks for help!