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" <[email protected]> wrote in message
news:[email protected]...
> 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
<[email protected]> 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?