Autofill to a number using a numerial value in a cel

[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

 

[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

 

[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