E elinks Mar 8, 2008 #1 Is it possible to create an excel template and have that template self-generate a new Invoice number each time it is opened?
Is it possible to create an excel template and have that template self-generate a new Invoice number each time it is opened?
G Gord Dibben Mar 8, 2008 #2 Tools>Options>General. Uncheck RiC1 reference style. Gord Dibben MS Excel MVP
G Gord Dibben Mar 8, 2008 #3 Right answer to wrong post. Gord Tools>Options>General. Uncheck RiC1 reference style. Gord Dibben MS Excel MVP Click to expand...
Right answer to wrong post. Gord Tools>Options>General. Uncheck RiC1 reference style. Gord Dibben MS Excel MVP Click to expand...
D Dave Peterson Mar 9, 2008 #4 You may want to look at the way J.E. McGimpsey approached it: http://mcgimpsey.com/excel/udfs/sequentialnums.html
You may want to look at the way J.E. McGimpsey approached it: http://mcgimpsey.com/excel/udfs/sequentialnums.html