take a look he

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html


In article ,
"Gilly" wrote:

I am trying to set up a template in Excel 2000 and would like to be able to
automatically number each invoice as the template is 63opeed to a new
document, can anyone tell me in basic terms if this is possible and how to do
it please?