How to add automated numbering on Excel Document

  • Thread starter Thread starter Sandy
  • Start date Start date
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.
 
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.
 
Did you ever get an answer to this, because excel's
capable but there help on it is not good.
 
Back
Top