(Solved) – Automatic generate invoice number every new month with VBA Excel


How can I generate a continuous invoice number that could reset every new month with VBA? With a format of mmyy######.

For example, the month is March 2020, the first invoice will be 032000001 then the second one will be 032000002. When next month comes, the first invoice of the month would then become 0420000001 and so on.

Please help.

Thank you very much

Leave a Reply

Your email address will not be published. Required fields are marked *