Automatic Invoice Numbering

I have been working on this for a few days now, trying to get this done by myself but just cant seem to find the right way.

I have created a list that has invoice numbers that will automatically be used based on the information given by a template that I have created. I cant use the same Invoice number again so each time this template asks for an invoice number a new one needs to be given. The template is basically a workbook that has all of the information that I need on a day to day basis. The list has the invoice numbers that I need but i also want to know to what file this invoice number is going to. I want the template to insert information into the list to track the invoice number. Can this be done and if so is there a direction someone could push me in to get me on the right track? I have gone thru the excel bible twice with no luck. Thanks!

Hello Hockeyman,

To save the invoice number on the same machine as the template, add these 2 VBA statements to your Template code...
SaveSetting, and GetSetting.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

I thank you for your help!

I'm sorry I don't understand what you are referring to with this code. I've tried to get information on what you are talking about but just get more confused.

Hello Hockeyman,

If you post your template, I'll add the necessary code for the invoice number.

Thanks,
Leith Ross

I want to thank you very much for your time! It is greatly appreciated!

Cell "m5" of the template file is where I would like the invoice number to be inputed. On the BMT invoice number file the information from the other cells will be inputed from cells in the template file. If I have done this wrong at all feel free to holler at me! Thank you very much!

Hello Hockeyman,

The macros have been added. The default invoice number is 1. It will advance by 1 each time you click the New Invoice button.

New Invoice Macro

Please Login or Register  to view this content.

Get Last Invoice when Workbook Opens

Please Login or Register  to view this content.

Sincerely,
Leith Ross

hi guys...

I have tried out the excel files above and adapt them for my porpose but im no programmer and am getting no-where, attached is the excel file that im using as my invioce system all i want to do is make the invoice number in the top right seqeuntial and when saving it creates a list of invoices and who they went to in a seperate exel file so i can keep track of them but i cant get it right. to try adapt the above scripts please help...and how do i reset the number to one again?


Thanks

Simply change the invoice number into "1" and click save.