software

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!

JohnFirst you have to save your PO as a template, then open new documents via
Filegt;New and select your template!

Regards,
Stefi?ohn??ezt ?rta:

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

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