I agree with what Joel wrote:

But you may want to look at the way J.E. McGimpsey approached it:
http://mcgimpsey.com/excel/udfs/sequentialnums.html

Office Admin wrote:

I am setting up a workorder sheet that will be printed and saved. I would
like the workorders to have numbers automatically - the number in the cell
would increase by 1 each time I opened the master sheet. Is this a macro, a
button? I have Excell 2003.

--

Dave Peterson