Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Liz Liz is offline
external usenet poster
 
Posts: 133
Default How do I automatically generate an invoice number

I am trying to create my own invoices - however I'm having no luck with
generating new invoice numbers. For instance I process invoice 001 and save,
followed by processing my second invoice which does not automatically
generate the next invoice number 002, & so on. Could someone please
assist???? Thanking you

Regards, Liz
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,365
Default How do I automatically generate an invoice number

J.E. McGimpsey has a solution that many people find suitable:
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html


"Liz" wrote:

I am trying to create my own invoices - however I'm having no luck with
generating new invoice numbers. For instance I process invoice 001 and save,
followed by processing my second invoice which does not automatically
generate the next invoice number 002, & so on. Could someone please
assist???? Thanking you

Regards, Liz

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
increasing invoice number automatically Froggy68 Excel Worksheet Functions 5 December 19th 06 12:10 AM
automatically number invoice Richard Excel Discussion (Misc queries) 2 October 19th 06 06:06 PM
How do I generate a new invoice number when creating new invoice? KiddieWonderland Excel Discussion (Misc queries) 1 March 15th 06 03:19 AM
how does an invoice number change automatically ? JudyRuiz New Users to Excel 2 April 8th 05 02:31 PM
Automatically number invoice Jaladino Excel Worksheet Functions 0 February 22nd 05 03:12 PM


All times are GMT +1. The time now is 07:22 AM.

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

About Us

"It's about Microsoft Excel"