IS THERE A AUTO TEMPLATE FOR INVOICES

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ej - 09 Jan 2006 03:09 GMT

Is there a template available that would fill in invoice numbers autmatically
when opened with a new number?

Reply to this Message

Paul B - 09 Jan 2006 03:48 GMT

ej,
A simple way would be to use something like this, in an open event.
Sheets("Sheet1").Range("A1").Value = _
Sheets("Sheet1").Range("A1").Value + 1

For other ways to do this or if this is going to be used in a temple have a
look here
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

Signature

Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

> Is there a template available that would fill in invoice numbers autmatically
> when opened with a new number?

Reply to this Message