Hello everyone,
I have in my spreadsheet a worksheet named historical errors, each row in this worksheet corresponds to a day.
This worksheet is refreshed with html data everyday.
There is another worksheet in the the same spreadsheet that is linked to the historical errors worksheet. When I refresh the historical errors worksheet this linked spreadsheet inserts just the last row from the historical error in itself.
So for instance if I refreshed the historical error and 8 rows were inserted related to April 10 to April 18, on the linked spreadsheet only the row related to April 18 will be inserted.
This is spreadsheet is linked using ='Historical Error'!B1073
How can I make the linked spreadsheet insert all refreshed rows from Historical Error, can someone help me with this?
I have in my spreadsheet a worksheet named historical errors, each row in this worksheet corresponds to a day.
This worksheet is refreshed with html data everyday.
There is another worksheet in the the same spreadsheet that is linked to the historical errors worksheet. When I refresh the historical errors worksheet this linked spreadsheet inserts just the last row from the historical error in itself.
So for instance if I refreshed the historical error and 8 rows were inserted related to April 10 to April 18, on the linked spreadsheet only the row related to April 18 will be inserted.
This is spreadsheet is linked using ='Historical Error'!B1073
How can I make the linked spreadsheet insert all refreshed rows from Historical Error, can someone help me with this?
