Sometimes, a simple approach is best. This question can be answered two ways in my opinion.
The first way (simple) is to have you enter the text "Work Order #" (without the quotes) in cell A1 of sheet1.
Then, paste this macro into a standard module, or copy & paste only the one line
Sheet1.[B1] = Sheet1.[B1] + 1
into a Workbook_Open event module:
Sub Aut
pen()
Sheet1.[B1] = Sheet1.[B1] + 1
End Sub
Every time you open your workbook, A1 and B1 will look like
Work Order # 1
and then
Work order # 2, etc, incrementing upward by one.
The more complicated solution would be to write code that takes into account the text "Work Order #" if you want that with the actual number in one cell. The code is not difficult, just more complicated-looking for your co-workers who may have to modify the file in your absence.
This first simple option is more intuitive for people to understand, and needs no adjustment, if for example your text changes from "Work Order #" to "Invoice Number".
If you need a different solution that what I gave here, please repost.
Tom Urtis