Invoice numbering

[mikie1881]

Hi. I use to provide electronic invoice for my services, but every time i forgot the last invoice number. is it possible to get some help ? I thing will be perfect if after doing and save an new invoice to be archived with a invoice name ? and invoice template to remain blanc ?the invoice number have to be on L3 cell of my invoice. Thank you in advance

 

[mikie1881]

Hi, thank you for your reply and for the correction of the code , its perfect but one thing that maybe I didn’t explain to you well.

I have one invoice template and I use it to issue any new invoices, what I am try to do is after complete with client details on template invoice on cells A13:K18 and push the macro button the invoice to be saved on c\aa (as it is saved already) with the data on A13:K18 and the invoice template to be cleared (A13:k18)

Unfortunately now when I click the macro button the template invoice cleared on A13:K18 But the copy saved on c\aa\inv empty without any data on A13:K18

Once again thank you very much

Mikie

thank you for your hekp
Regards
Mikie

 

[Logit]

Nothing has changed from the previous (your Post #6) concerning the code logic. Instead of performing the same functions in two separate macros, the code now
performs the same functions by combining the two macros into one macro.

I don't understand how the code is doing something different ...

 

[mikie1881]

I canot say why because i dont have the skills but , on previus code the second fuction was not worked , now works perfect , and thanks again for that.
By the way can i change the name of the saved file from inv(l3) to inv ( L3 + A6) ?? this will save the copy with the client name and the invoice number ??
Best Regards
Mikie

 

[Logit]

Certainly.
Edit : NewFN = "c:\aaa\Inv" & Range("l3").Value & ".xlsx"

To: NewFN = "c:\aaa\Inv" & Range("L3").Value & Range("A6").Value & ".xlsx"

 

[mikie1881]

Works perfect
Thank you for all
Regards
Mikie

 

[Logit]

You are welcome.