ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   macro to increase invoice number and save (https://www.excelbanter.com/excel-programming/321319-macro-increase-invoice-number-save.html)

Toinett

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.


Paul B

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.




JE McGimpsey

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.


JulieD

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.





All times are GMT +1. The time now is 12:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com