How do I create a counter for invoices, order numbers etc
Our new business is creating invoice, order number etc templates and we are
wondering if it is possible to have excel automatically apply the next number as each document is created for each new transaction? If so how is it done? If not, are there any other Microsoft Office programs that have this feature? |
Click here and do a search for "Invoice":
http://www.vbaexpress.com/kb/kblist.php You'll find several options. ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "nolanpatrick" wrote in message ... Our new business is creating invoice, order number etc templates and we are wondering if it is possible to have excel automatically apply the next number as each document is created for each new transaction? If so how is it done? If not, are there any other Microsoft Office programs that have this feature? |
See JE McGimpsey's site for help on this.
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html Gord Dibben Excel MVP On Tue, 5 Jul 2005 15:07:03 -0700, nolanpatrick wrote: Our new business is creating invoice, order number etc templates and we are wondering if it is possible to have excel automatically apply the next number as each document is created for each new transaction? If so how is it done? If not, are there any other Microsoft Office programs that have this feature? |
All times are GMT +1. The time now is 07:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com