Need a way to create invoice numbers automatically

[Thriftlife]

Hey needing a way for my company to use the invoice we have created and create a bunch of copies of it and give it its own unique invoice number.
The cell the invoice number will be in is I4
i would like it to save each copy as the same name as the invoice number, if thats possible. Or at least save each file without going in and manually saving each one.
We usually make 1300 or more copies of invoices that employees fill out, so trying to make it easier on us
,Thamks

 

[RayFrye]

You asked if possible, most any notion you can think of is possible with any programming language including VBA.
Do I understand you correctly:
You have one invoice with a number say 100, maybe in a file named 'Invoice 100'.
You want to make 1,300+ copies of 'Invoice 100' each with a different number, maybe named 'Invoice 1 Based on 100' to 'Invoice 1300 based on 100'.
Save those 1,300+ invoices in a file named 'Invoice 1 Based on 100' to 'Invoice 1300 based on 100'.
Then somehow you print and distribute these 1,300+ invoices for your employees.
The code will be simple enough, your logistics look like a challenge.

 

[Thriftlife]

Yea so each invoices will be named the same as their invoice number. So invoice 12345 will be called 12345.xlsm as a example

 

[RayFrye]

And there will be 1,300 invoices starting with 1.xlms to 1300.xlms each the same as 1.xlms.
You are adding some piece of information you have not share to get to 12345.xlsm.

 

[Thriftlife]

All invoices files will be the exact same as the others just different invoice numbers in cell I4.

 

[Thriftlife]

..

 

[Fluff]

Cross posted Need a macro created for my invoicess

While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[Thriftlife]

Can anyone else help with this ?

 

[jamiemarie]

This isn't entirely what you are looking for, but I recently used this to create sequential invoices. Maybe it could be a start?

How to Make Invoice Number Change Automatically in Excel

To make an invoice number change automatically in excel, you will need to add a macro to the document. We’ll go through how to do this, step by step.

www.freshbooks.com

 

[Thriftlife]

Yea i got it to chnage the number when i open the file, wondering how to open, close and rename the document with sequential names.