Jun 20 2019 08:35 AM
I am looking for a function that would allow me to auto fill a certain number of rows based on data entered in the first row.
So, say I want to fill 20 rows, I'd want the function to automatically fill them in when I fill in the first cell.
Is there a function that can do this?
It was suggested that I use the IF function to generate the needed number of rows, but I don't see how this would work.
Can someone explain or give another idea?
Jun 20 2019 11:59 AM
Jun 20 2019 01:13 PM
In simple variant
in C4
=IF(ROW()-ROW(StartCell) <=CellsToFill, StartCell, "")
and drag it down with some gap against your possible range
Jun 20 2019 01:17 PM