Automatic numbering when opening document

[john]

I know there is a way in Excel to have a document be numbered with a
unique sequential number each time it is opened (or better yet, each
time it is opened after having been saved). (For example, let's say
that I want to create a purchase order form that can be used by
multiple people. I would like the PO to be automatically and uniquely
numbered each time it is opened). Can anyone provide the formula to do
so? Thanks!

John

 

[Guest]

First you have to save your PO as a template, then open new documents via
File>New and select your template!

Regards,
Stefi


„john†ezt írta:

 

[john]

Thanks for your response. I'm not sure this answers my question. My
file has been saved as a template. I want a unique sequential number
to appear every time the file is opened. Meaning, the first time it is
opened the number could be 101. The next time the template is used,
the file should open with 102 in the designated field.

Any thoughts on how to accomplish this?

John