ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Insert a progressive invoice number (https://www.excelbanter.com/excel-worksheet-functions/148626-insert-progressive-invoice-number.html)

George B

Insert a progressive invoice number
 
I have created a great invoice workbook for myself; I have everything linked
exactly as I want it. The only problem I have is I don't know how to make the
invoice number change after every save. Until I can do this, my workbook sits
idle. Can someone please help me? I greatrly appreciate any help I can get.
--
Have a wonderful day.

Pete_UK

Insert a progressive invoice number
 
J.E. McGimpsey shows how if you follow this link:

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

Hope this helps.

Pete

On Jul 1, 8:20 pm, George B wrote:
I have created a great invoice workbook for myself; I have everything linked
exactly as I want it. The only problem I have is I don't know how to make the
invoice number change after every save. Until I can do this, my workbook sits
idle. Can someone please help me? I greatrly appreciate any help I can get.
--
Have a wonderful day.




Toppers

Insert a progressive invoice number
 
Take a look he

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

"George B" wrote:

I have created a great invoice workbook for myself; I have everything linked
exactly as I want it. The only problem I have is I don't know how to make the
invoice number change after every save. Until I can do this, my workbook sits
idle. Can someone please help me? I greatrly appreciate any help I can get.
--
Have a wonderful day.


Stan Brown

Insert a progressive invoice number
 
Sun, 1 Jul 2007 12:20:02 -0700 from George B
:
I have created a great invoice workbook for myself; I have everything linked
exactly as I want it. The only problem I have is I don't know how to make the
invoice number change after every save. Until I can do this, my workbook sits
idle. Can someone please help me? I greatrly appreciate any help I can get.



http://www.google.com/search?q=excel...ique+number%22


--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/

George B

Insert a progressive invoice number
 
Not only was this information excatly what I needed, but faster than I could
have ever expected. Thanks so very much to all of you. Now I can finish my
project. **Big handshake to you all**
--
Have a wonderful day.


"Pete_UK" wrote:

J.E. McGimpsey shows how if you follow this link:

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

Hope this helps.

Pete

On Jul 1, 8:20 pm, George B wrote:
I have created a great invoice workbook for myself; I have everything linked
exactly as I want it. The only problem I have is I don't know how to make the
invoice number change after every save. Until I can do this, my workbook sits
idle. Can someone please help me? I greatrly appreciate any help I can get.
--
Have a wonderful day.






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

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