I need to create a sequence number for customer return manage in my database. The sequence number should be written in Column A, with an order as below:
-Start with the last two number of running year (example: 20 for 2020)
-running month "04" for April, "05" for May and so on...
-purchase platform "C" for CMI, "A" for Amazon (choose from user form)
-and sequence number 001
So for Amazon return it will be like: 2004-A001 and for the next Amazon return will be 2004-A002. Same for CMI return, it will be like" 2004-C001 and for the next company return will be 2004-C002.
I have created the user form for all other data entry, but had no idea how to write code for this conditional sequence number. Any insights or feedback would be much appreciated.
PS: I have attached my workbook here if you are interested to take a look at more details
Thank you all in advance for your attention and helping hands!