| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbering Invoice
Is it possable to have Xcel set up so that every time you open it to print an
invoice the invoice number is one more then the last one? Thanks Dave |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Numbering Invoice
Hi Dave,
http://mcgimpsey.com/excel/udfs/sequentialnums.html try it hth regards from Brazil Marcelo "DaveO" escreveu: Is it possable to have Xcel set up so that every time you open it to print an invoice the invoice number is one more then the last one? Thanks Dave |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Numbering Invoice
You will need to employ a little VBA.
See John McGimpsey's site for code. http://www.mcgimpsey.com/excel/udfs/sequentialnums.html Gord Dibben MS Excel MVP On Fri, 21 Jul 2006 13:03:01 -0700, DaveO wrote: Is it possable to have Xcel set up so that every time you open it to print an invoice the invoice number is one more then the last one? Thanks Dave Gord Dibben MS Excel MVP |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Invoice Numbering | Excel Discussion (Misc queries) | |||
| sequential invoice numbering | Excel Worksheet Functions | |||
| How do I set up excel invoice t/plate with sequential numbering | Excel Discussion (Misc queries) | |||
| Invoice Numbering | Excel Worksheet Functions | |||
| Master invoice number | Excel Worksheet Functions | |||
Linear Mode
