Need Help with automatic generated rows!

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!


Please sign in to leave a comment.