ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   An incrementing serial number in each new document (https://www.excelbanter.com/excel-discussion-misc-queries/136601-incrementing-serial-number-each-new-document.html)

Lee Techwriter

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


All times are GMT +1. The time now is 01:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com