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!

**Clarification**

I see that my meaning was not understood.

I have `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: