Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set up invoices to automatically change invoice numbers?
I use an excel invoice for my small business and would like to have the
invoice number change automatically with each new invoice created. Please Help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set up invoices to automatically change invoice numbers?
Scotiagolf,
A simple way would be to use something like this, you could assign it to a button, an open or before print 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 "Scotiagolf" wrote in message ... I use an excel invoice for my small business and would like to have the invoice number change automatically with each new invoice created. Please Help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Graph colors automatically change | Charts and Charting in Excel | |||
change default chart settings for new excel charts automatically | Charts and Charting in Excel | |||
Master invoice number | Excel Worksheet Functions | |||
How do I automatically calculate YTD numbers by changing a date? | Excel Worksheet Functions | |||
Is there an automatic way to change numbers such as 12312001 t | Excel Discussion (Misc queries) |