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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---