|
| 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
January 21st 05, 02:27 PM
posted to microsoft.public.excel.programming
|
|||
|
|||
macro to increase invoice number and save
I'm using XP. I am trying to get the invoice I've created to clear, increase
the invoice number by one and save ready for the next use. I'm open for suggestions for a more efficient invoice set up. 
|
| Ads |
|
#2
January 21st 05, 02:37 PM
posted to microsoft.public.excel.programming
|
|||
|
|||
|
macro to increase invoice number and save
Toinett, 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 "Toinett" > wrote in message ... > I'm using XP. I am trying to get the invoice I've created to clear, > increase > the invoice number by one and save ready for the next use. I'm open for > suggestions for a more efficient invoice set up. >
|
|
#3
January 21st 05, 02:41 PM
posted to microsoft.public.excel.programming
|
|||
|
|||
|
macro to increase invoice number and save
Take a look he
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html In article >, "Toinett" > wrote: > I'm using XP. I am trying to get the invoice I've created to clear, increase > the invoice number by one and save ready for the next use. I'm open for > suggestions for a more efficient invoice set up.
|
|
#4
January 21st 05, 04:13 PM
posted to microsoft.public.excel.programming
|
|||
|
|||
|
macro to increase invoice number and save
Hi
if you'ld like to email me direct (julied_ng at hcts dot net dot au) i have a sample invoicing workbook that you can have a look at and maybe get some ideas from or customise for your own purposes. Cheers JulieD "Toinett" > wrote in message ... > I'm using XP. I am trying to get the invoice I've created to clear, > increase > the invoice number by one and save ready for the next use. I'm open for > suggestions for a more efficient invoice set up. >
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| how do i increase invoice number everytime its opened? | stacey | Excel Discussion (Misc queries) | 1 | March 3rd 06 10:37 AM |
| set increment increase in invoice number it | tiredstudent | Excel Discussion (Misc queries) | 1 | December 1st 05 06:21 PM |
| Excel,increase Invoice Number At Start | LIGER | Excel Discussion (Misc queries) | 1 | June 17th 05 05:19 PM |
| Increase the number of the invoice | Gord Dibben | Excel Worksheet Functions | 0 | January 25th 05 12:43 AM |
| How to make the invoice number increase | Albert Chong | Excel Programming | 1 | November 29th 03 11:24 AM |
Linear Mode
