Forum Discussion
CREATE AN EVOLUTIVE AMORTIZATION SHEET
I'M LOOKING FOR THE BEST WAY TO CREATE A SHEET WHOSE THE NUMBER OF LINES CHANGE ACCORDING TO A VARIABLE. FOR EXAMPLE AN AMORTIZATION SHEET WITH A DEPRECIATION PERIOD WHICH CAN CHANGE? AND THE NUMBER ...
The basic Excel function that allows you to generate data into multiple rows (or multiple columns) is the SEQUENCE function. See the attached workbook, including notes on the _Info worksheet.