Forum Discussion

Copper Contributor

Aug 08, 2019

Solved

Creating a formula to autofill a range of cells based on input

Hello, I am trying to create a formula that takes the input from a cell and fills a range of cells based on the numerical value entered. I'm not sure if there is a default function to a EX: If ...

admin

BI & Data Analysis

excel

Formulas and Functions

Macros and VBA

PReagan
Aug 08, 2019
Hello tazewellj,

Enter this formula into cell A2 and use cell B1 to input your number:

=IF(ROW(A2)-1>$B$1,"",ROW(A2)-1)

Then copy the formula down as necessary.

Hope this helps!
PReagan

PReagan

Bronze Contributor

Aug 08, 2019

Hello tazewellj,

Enter this formula into cell A2 and use cell B1 to input your number:

=IF(ROW(A2)-1>$B$1,"",ROW(A2)-1)

Then copy the formula down as necessary.

Hope this helps!
PReagan

tazewellj

Copper Contributor

Aug 08, 2019

PReagan thanks for your quick response. Unfortunately this always returns a value of 1 in cell A2. This is a great start, but I am trying to create a formula that will fill a range of cells. For instance, if I the value 3 in cell B1, I would like cells to filled as followed:

A2 1

A3 2
A4 3

My goal is to have a numbered rows based upon user input.

Thanks,
tazewellj