I have an excel file that relies on an external CSV file which I reload from time to time.
The csv is loaded into a sheet and a different sheet is used to perform calculations.
My question is - How do I extend the formula to the number of rows on the external data sheet?
Thanks in advance!
I see that my meaning was not understood.
x rows in the source table.
I need to have
x rows in the computation table.
How do I automaticaly fill the target computation table with 10 rows (they will all be formulas) For example:
Before the reload the src table had 3 rows, so the target table will have 3 rows of formula
after the refresh 3 rows were added to the source. I want the target to automatically add 3 rows of formula: