Auto numbering new worksheet versions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I add an autonumber field in my excel template so it incrementally changes each time a user opens it?
 
Is it really a template or is it a workbook that you are using and then
doing saveAs.

In any event, there is no built in autonumbering facility. You would have
to manage this with code. It it is a true template, used with File=>New,
then you would have to store the values somewhere else similar to the
Invoice template distributed with Excel. I believe it uses the registry.

--
Regards,
Tom Ogilvy


jlbaz said:
How can I add an autonumber field in my excel template so it incrementally
Click to expand...
changes each time a user opens it?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Increment Cell Value on Worksheet Change 6
Excel Template Question... 2
Data Entry Form and Auto Number ID 2
Excel worksheets auto-incremeting question 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Auto Increment Field or Identity Field In MS SQL Server 0
getting new workbook name from opened template 1
Insert data into SQL Server db - find out the record number 6

Back
Top