ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   enter ascending numbers to excel invoice template (https://www.excelbanter.com/excel-worksheet-functions/179311-enter-ascending-numbers-excel-invoice-template.html)

elinks

enter ascending numbers to excel invoice template
 
Is it possible to create an excel template and have that template
self-generate a new Invoice number each time it is opened?

Gord Dibben

enter ascending numbers to excel invoice template
 
ToolsOptionsGeneral.

Uncheck RiC1 reference style.


Gord Dibben MS Excel MVP

On Sat, 8 Mar 2008 15:10:00 -0800, elinks
wrote:

Is it possible to create an excel template and have that template
self-generate a new Invoice number each time it is opened?



Gord Dibben

enter ascending numbers to excel invoice template
 
Right answer to wrong post.


Gord

On Sat, 08 Mar 2008 15:38:43 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

ToolsOptionsGeneral.

Uncheck RiC1 reference style.


Gord Dibben MS Excel MVP

On Sat, 8 Mar 2008 15:10:00 -0800, elinks
wrote:

Is it possible to create an excel template and have that template
self-generate a new Invoice number each time it is opened?



Dave Peterson

enter ascending numbers to excel invoice template
 
You may want to look at the way J.E. McGimpsey approached it:
http://mcgimpsey.com/excel/udfs/sequentialnums.html

elinks wrote:

Is it possible to create an excel template and have that template
self-generate a new Invoice number each time it is opened?


--

Dave Peterson


All times are GMT +1. The time now is 10:12 AM.

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