View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Stefi
 
Posts: n/a
Default Automatic numbering when opening document

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

Regards,
Stefi


€˛john€¯ ezt Ć*rta:

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