Does this really make sense (create new order when opened)? What happens if
somebody want to look at the worksheet and not create a new Order?

It is better to create a new number using a button or when somebody starts
typing in a specific cell.

"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.