In addition, make sure you have ToolsOptionsCalculation set to "Automatic"


Gord Dibben MS Excel MVP

On Tue, 25 Mar 2008 07:33:00 -0700, Max wrote:

A46 says, =IF(B45="","",B45)
Just drag the fill handle* of cell A46 down as far as required, to fill the
formula in advance of expected data. The formula will auto-increment as
desired, and the formula cells will appear "blank" until data is entered in
col B.
*that's the solid black square at the bottom right corner of the cell