incremanting numbers

[Paul Capille]

Please help
I've created an invoice using Excel 2000 and saved it as a template. Is
there any way that the invoice number could increment by one each time the
template is opened?
Many thanks
Paul

 

[Bob I]

Automatic macros, such as Autpen, are designed to run when you start
Excel. For more information about these macros, see Microsoft Visual
Basic Help.

 

[garfield-n-odie]

Hi, Paul. See http://word.mvps.org/FAQs/MacrosVBA/NumberDocs.htm.

 

[Bernard Liengme]

Paul,
Questions like this are best asked on an Excel newsgroup such as
microsoft.public.excel.misc
The question has been answered many times. Go to Google, click on Group and
do an advanced search: group -> *excel*; word to find-> invoice

Best wishes