Forum Discussion
Auto Fill using a formula
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 ...
In simple variant
in C4
=IF(ROW()-ROW(StartCell) <=CellsToFill, StartCell, "")
and drag it down with some gap against your possible range
Depending on the OP's actual needs, this is inherently bad practices, for the reasons I specified above. Also, when using named ranges in your formulas in lieu of absolute cell referencing, it's probably best to qualify them.
Kind regards
Kind regards