Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Invoice Numbering in Excel 2003
I have created an invoice in Excel 2003 which I would like a consecutive
invoice number to be assigned to each invoice. I cannot figure out to create one. I do know that the number I wish to start my invoices with needs to be saved in notepad or wordpad. That's as far as I was able to get. Can someone help? Thank you |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Invoice Numbering in Excel 2003
Hi
maybe: http://www.mcgimpsey.com/excel/udfs/sequentialnums.html -- Regards Frank Kabel Frankfurt, Germany "Greg Lane" <Greg schrieb im Newsbeitrag ... I have created an invoice in Excel 2003 which I would like a consecutive invoice number to be assigned to each invoice. I cannot figure out to create one. I do know that the number I wish to start my invoices with needs to be saved in notepad or wordpad. That's as far as I was able to get. Can someone help? Thank you |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Invoice Numbering in Excel 2003
using some simple code might do what you want:
Assume cell A1 contains the invoice number. Name cell A1 as InvNum then in a code module: Sub IncrementInvNum() Range("InvNum") = Range("InvNum") + 1 End Sub This sub needs to be called by the same action that creates a new blank invoice. If you are using a Template, then in the ThisWorkbook module use: Private Sub Workbook_Open() IncrementInvNum End Sub If you are creating a new blank invoice with a command button, put the call inside the macro which is assigned to the button. "Greg Lane" wrote: I have created an invoice in Excel 2003 which I would like a consecutive invoice number to be assigned to each invoice. I cannot figure out to create one. I do know that the number I wish to start my invoices with needs to be saved in notepad or wordpad. That's as far as I was able to get. Can someone help? Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
is there an auto-numbering tax invoice templete for excel | Excel Discussion (Misc queries) | |||
How do I set up excel invoice t/plate with sequential numbering | Excel Discussion (Misc queries) | |||
Is auto invoice numbering possible in Excel 2003? | Excel Discussion (Misc queries) | |||
In Excel, how do I setup sequential numbering on an invoice? | Excel Worksheet Functions | |||
How do I set up invoice automatic numbering in excel? | Excel Discussion (Misc queries) |