Hi

J E McGimpsey has a method for achieving this on his site at
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

--
Regards

Roger Govier


"merlin2ate" wrote in message
...
is it possible to program a cell within a Template to automatically
advance
by one number each time a new sheet started? I am trying to program
the
"Invoice that calculates sales tax and total" to advance the invoice
number
automatically.