How to add automated numbering on Excel Document

S

Sandy

I would like to have the Excel document form
automatically add a number in sequence so we can track
each document.

For example:

We have paper forms with assigned ID numbers for tracking
reference. How can you get Excel to perform an automatic
ID tracking number each time a new form needs to be used.

Thanks for your help.
 
J

Jim

One way is with to put this in the Workbook_Open event:
Range("A1").Value=Range("A1")+1

Of course, you need to change the cell reference to meet your needs.
 
G

Guest

Did you ever get an answer to this, because excel's
capable but there help on it is not good.
 

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

Numbering documents 1
How do I set up an automated numbering system For my "Invoice Num 1
COUNT rows on external sheet if between date range 3
Automatic Numbering 1
Adding automated content to existing fields 2
automated cut and paste using regex 2
Excel 2003 Add-ins - Assign Number 3
Excel How to add a calendar month to and existing excel file created in a template 1

Top