Google sheets dynamically populate cells based on single cell value. I don't know what the term would be called and a bunch of searching hasn't resulted in any lead on what it would be called.
What I would like to do is populate
X number of rows with the formulas based upon a cell that has the number value of
An example would be an amortization sheet for a loan. If you have a cell that contains the term years
15 that's 180 periods (
15*12). The formula is the same for each column and dragging them down 180 rows would give me the same results it would auto-populate the cells. If I then changed the term cell value to
30 years loan I would have to drag it another 180 rows for a total of 360.
Instead, I'm trying to figure out how to have the sheet auto-fill the values based on the term cell number. It would then auto-populate the rows based on that value.
What is this term called or how could I go about doing this? Do I need to create my own macro in the sheets script?