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.
Thank you very much