Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default Automating to generate the next Invoice No.

In excel; is there a way to automate the next invoice number.
This will help a lot. We manually generate invoices, but instead of
remembering the last invoice number; Is it possible to automate this number;
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 292
Default Automating to generate the next Invoice No.

Yes. See
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html
for solutions.

HTH. best wishes Harald

"Murad Sheikh" skrev i melding
...
In excel; is there a way to automate the next invoice number.
This will help a lot. We manually generate invoices, but instead of
remembering the last invoice number; Is it possible to automate this
number;



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default Automating to generate the next Invoice No.

Sounds like a possible solution. Will give it a go and get back.
Thanks Herald for the link to the solution.
Murad

"Harald Staff" wrote:

Yes. See
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html
for solutions.

HTH. best wishes Harald

"Murad Sheikh" skrev i melding
...
In excel; is there a way to automate the next invoice number.
This will help a lot. We manually generate invoices, but instead of
remembering the last invoice number; Is it possible to automate this
number;




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 automatically generate an invoice number Liz Excel Worksheet Functions 1 December 1st 07 03:16 PM
generate a random number and use if function to generate new data Dogdoc1142 Excel Worksheet Functions 4 April 26th 06 03:44 AM
How do I generate a new invoice number when creating new invoice? KiddieWonderland Excel Discussion (Misc queries) 1 March 15th 06 03:19 AM
Invoice templet Excel97 to 2003 invoice toolbar missing MarolynInMarion Excel Discussion (Misc queries) 0 August 19th 05 07:15 PM
how do i generate invoice from excel datafile? jm Excel Discussion (Misc queries) 1 August 16th 05 07:41 PM


All times are GMT +1. The time now is 11:07 PM.

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

About Us

"It's about Microsoft Excel"