dlefebvre, have a look here
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"dlefebvre" wrote in message
...
Working with an invoice type setup, I need excel to look to the previous
sheet and add 1 to it creating the next invoice number in line. So that
when
I create a new sheet it will automatically create the next available
number
without having to go and manually enter the reference sheet each time. Is
this an array function? Can anyone give direction as to the number system
I'm
looking for?