Im currently trying to implement sequential numbering for our €œhomemade€�
purchase, order and invoice system.
There are 4 conditions to consider:
1. There are several series of number, i.e. 1 for purchases, 1 for orders,
etc.
2. The number shall be picked when starting the new registration and be
finally confirmed and written at the completion of the registration (I might
cancel during registration)
3. The numbers/file shall be stored on a server volume for shared use by the
workgroup.
4. We oversee the risk of using the same number simultaneously.

A couple of years ago I wrote a fax document system for Word. In Word you have
the function of a System.PrivateProfileString. It works excellently as you
easily can share a textfile with Labels for retrieving and saving different
information, even sections can be used. Its easily read from and written to.
Unfortunately it doesnt exist in Excel!

Is it possible to do something similar in Excel.
Ive read McGimpseys solution but it doesnt tell how to read first and
write later.
I also would like to use several labeled address lines, storing all the
different numbers in one file.