Autofill to a number using a numerial value in a cel

G

gacollege

Here is my Excel problem for the day.... I have a spread sheet tha
contains a column that needs to be autofilled (add 1 to each line
until it reaches a certain specified number in a cell.

In other words....

In cell A1 "Cartons"
In cell A2 154

In cell B1 "Label #"
In cell B2 29542

I need to have a formula that would start in cell B3 and add 1 to th
number 29542 until it reaches 29695. (I am thinking I would have t
use an IF function that would see if any value lies in cell A2 tha
would warrant the calculation).

THANKS for any help!
Richar
 
K

KellyMcG03

I'm sorry, but your post seems very vague. What type of conditions ar
there for the autofill?

Maybe this is what you are looking for, just fill this down th
column...

=IF(B2=29695,"",B2+1)

If B2 equals 29695, do nothing, if not, add 1
 
B

Bernie Deitrick

Richard,

In B3, use the formula

=IF($A$2<>"",IF(ROW()-2<$A$2,B2+1,""),"")

and fill down for as many rows as you need.

HTH,
Bernie
MS Excel MVP
 
Top