Excel's Ability to Apply Serial Numbers
Posted by Diana Johnson on November 30, 2001 5:13 PM
Can Excel auto-serialized forms (a Purchase Requisition form)as they are downloaded from a network drive?
The spreadsheet file would be on the network. The user would click on the shortcut and Excel and the Purchase Requisition form would load. At this point the serial number would increment by one so that the user sees the next serial number in sequence on the Purchase Requisition form. The user would complete the form and email it to the purchasing agent. So, each time someone loaded/accessed the form, the next serial number would appear.
There will be numerous users. Each user would have a unique serial number on their purchase requisition (in order to track the requisition). Thanks for your help.