in b2=row()*5+1000 and copy down
Then DELETE the blank row(s)

Don Guillett
Microsoft MVP Excel
SalesAid Software

"Josh W" wrote in message
...
I have the following number series:
B1=1000
B2=1005
B3=1010
B4=1015
B5=1020
B6+1025
etc etc all in increments of 5. However, I have some completely random
cells
in the same column that I must leave blank. Since I used the fill handle
to
copy down the number series, how can I delete random cells and have the
number series readjusted automatically e.g as follows:
B1=1000
B2=blank
B3=1005
B4=1010
B5=blank
B6=1015
Greatly appreciate your help. Excel 2003.