You could add a formula: =if(isblank(b2),"",a2+1) would be it for row 3 if
you, for instance, type a date in column B. But you'd need a macro to make
it happen automatically.
************
Anne Troy
www.OfficeArticles.com


"JsJ" wrote in message
...
I just want to know how I can set up a column to auto generate numbers in
decsending order?