If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
IS THERE A AUTO TEMPLATE FOR INVOICES
Is there a template available that would fill in invoice numbers autmatically
when opened with a new number? |
#2
|
|||
|
|||
IS THERE A AUTO TEMPLATE FOR INVOICES
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 -- 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 "ej" wrote in message ... Is there a template available that would fill in invoice numbers autmatically when opened with a new number? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Global/Master Template | [email protected] | New Users | 1 | October 27th, 2005 03:34 PM |
How does a "fill -in" template (in Word) auto expand to second pag | Confused about templates | General Discussion | 1 | June 30th, 2005 05:10 PM |
CPU Usage When working with a Template I Created | KM1 | General Discussion | 6 | May 24th, 2005 04:38 PM |
Autotext exclusive to a new template | KM1 | General Discussion | 5 | January 26th, 2005 12:01 AM |
Mial merge data base problems | Rachael | Mailmerge | 16 | May 21st, 2004 06:22 PM |