Automatic numbering system

  • Thread starter Thread starter jm
  • Start date Start date
J

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?
 
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.
 
Back
Top