Hello Experts,
Good day to you all. Hope you can help me with my code. I am trying to create an invoice template in excel (Yes, I know Quickbooks does it) however, this is for a voluntary organisation that is starting out with limited funds. So far so good, because I tried to search through web and I managed to come up with this code. However, should I make it increment? Should it be automatic or is there some other way. Lastly I need the invoice number to take on this format: mm-yy-Inv#. Here is the code:
Thank you in advance,
Samia67
Good day to you all. Hope you can help me with my code. I am trying to create an invoice template in excel (Yes, I know Quickbooks does it) however, this is for a voluntary organisation that is starting out with limited funds. So far so good, because I tried to search through web and I managed to come up with this code. However, should I make it increment? Should it be automatic or is there some other way. Lastly I need the invoice number to take on this format: mm-yy-Inv#. Here is the code:
Code:
Sub NextInvoice()
With Range("I3")
.NumberFormat = "00000"
Range("I3").Value = Range("I3").Value + 1
Range("A25:I38") = ClearContents
End With
End Sub
Thank you in advance,
Samia67