View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lee Techwriter Lee Techwriter is offline
external usenet poster
 
Posts: 1
Default An incrementing serial number in each new document

I'm trying to create a trouble-ticket form with numerous blank fields, to be
filled in by users. I can handle that. What I can't figure out is how to
put in a field with a serial number in it that increments by one each time a
new form is created. I'm thinking that a template might do. The template
would remember the last serial number, and increment it by one when a
document is made from that template.

Any suggestions? If this takes VBA coding, I'm lost. I can record macros,
and touch them up in editing, but real coding is beyond me, at this point.

-- Lee Techwriter