Creating Serial Numbers for a form

  • Thread starter Thread starter DG
  • Start date Start date
D

DG

I have a user that created an sales order form in excel. He has an order
number that he must keep a manual record of and often duplicates the order
numbers.

What is the best way to automate this so that each time he opens the
spreadsheet the order number would increment by 1?

Since it is a blank form that the user opens and filles out the form and
saves it under another name, I could have a macro that when the form is
opened the serial number increments and save the file before the user enters
data. Is that the best way?

DG
 
See

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have a user that created an sales order form in excel. He has an order
| number that he must keep a manual record of and often duplicates the order
| numbers.
|
| What is the best way to automate this so that each time he opens the
| spreadsheet the order number would increment by 1?
|
| Since it is a blank form that the user opens and filles out the form and
| saves it under another name, I could have a macro that when the form is
| opened the serial number increments and save the file before the user enters
| data. Is that the best way?
|
| DG
|
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a sequentual serial no within a template 2
Create Fillable PDF Forms With LibreOffice Writer 3
create auto number field in task form 4
Bar chart for product sales 2
Dynamic form 3
DMax on existing record to increment serialized # fails 1
Increment a number based on instances in another table 1
Data Entry Form and Auto Number ID 2

Back
Top