Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 21st 05, 02:27 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2005
Posts: 5
Default 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.


  #2   Report Post  
Old January 21st 05, 02:37 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 709
Default 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   Report Post  
Old January 21st 05, 02:41 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 4,624
Default 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   Report Post  
Old January 21st 05, 04:13 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: May 2004
Posts: 618
Default 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.





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


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


All times are GMT +1. The time now is 05:50 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017