Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
=IF problem | Excel Discussion (Misc queries) | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
Need One Excel Template to copy to TWO Databases | Excel Discussion (Misc queries) | |||
Making a auto date entered into a cell permanent from a template | Excel Discussion (Misc queries) | |||
How do I auto number cells in an Excel template? | Excel Discussion (Misc queries) |