Using a template form, advance a form number everytime you open

S

ShoDan

How could I set up a spreadsheet that will show one cell with a changing
number every time the spreadsheet is opened? I am attempting to make an
invoice that will show an advancing number everytime I start a new one. I
would save the form as a template. Once I save the form I don't want it to
change again, it should remain the same.

Example: 0012345
0012346
0012347
Thanks in advance
John
 

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

assign auto number and auto date 2
Template 4
Auto Number 1
Saving a copy without incrementing number 10
how do I make an excel workbook into a reusable form 1
Help please 4
Extract data from form 3
running number sequences 1

Top