incremanting numbers

P

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
 
B

Bob I

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

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
 
Top