Hi

Take a look at the methods used by JE McGimpsey
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

--
Regards
Roger Govier

"Nenagh" wrote in message
...
I have a template, with data tracking. Currently when somebody uses the
template they type the next consecutive number in one of the cells.

I want this to be automated and chosen from a list of numbers, choosing
the
next avaialable?

Cheers
--
Nenagh