I am trying to write a Work Order entry form in Excel to simply a process and
automate what seems to be difficult for folks around here.

I have a Work Order form that has a number of data fill-in cells with other
cells protected. What I would like to do is two fold:
1) Have the spreadsheet automatically place a number in a cell called
"WorkOrderNum" that would be one more incrementally than the last file saved.
2) Have the Work Order worksheet automatically use that WorkOrderNum number
as the file name when it is saved.

The functionality is such that i'm hoping to have the non-computer users
here be able to open a single file which will automatically number itself as
outlined above and then save with the number for later reference if
necessary. Personally, I'd prefer using a single database with all these
numbers and worksheet data saved in each row/record. But, knowing how others
around here work, I don't think that will be possible.

I've poked through the Help system and read several entries here in the
forums but don't see exactly what I'm looking for. Any help or suggestions
are appreciated.
--
Steven Leuck
Builders Electric, Inc.