Automatic numbering system

[jm]

Hello,

I have created a Purchase Order for our company in
excel. I'd like this spreadsheet to be a template. This
is the scenario I am looking for.

Everytime an employee pulls up this spreadsheet, I'd like
the spreadsheet to automatically number itself
sequentially (example 0001). I'd like the number placed
in a cell on the spreadsheet and then the user saves this
spreadsheet. Another user goes to open the template and
it gets sequentially numbered 0002.

Any ideas?

 

[Frank Kabel]

Hi
though this kind of numbering could be achieved with a template you
have to define where you want to store the currrent number (If you had
only one user the registry could be such a place). But if you have more
users and you'll want to use a template (a *.xlt file) there has to be
a common file (e.g. a text file on your network server) to store the
current number.

For this kind of application I'd use a database which could be
accessed from multiple users simultaneously.