How to add automated numbering on Excel Document

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.


--
Greeting from the Gulf Coast!
http://myweb.cableone.net/twodays
"Sandy" wrote in message
...
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.

Did you ever get an answer to this, because excel's
capable but there help on it is not good.
-----Original Message-----
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.
.