Hi..
TBH I am new in VBA, programming and macros.
Currently, I am in a project where I need to register purchased item.
For every purchased, it will generate a sequence number based on format - KBMC/YY/xxxx where:
KBMC - my unique ID
YY - last 2 digit purchased item year
xxxx - sequence number
i am using this code
currently the outcome is like this :
KBMC/19/0001
KBMC/19/0002
KBMC/19/0003
KBMC/20/0004 - THIS IS DIFFERENT DATE/YEAR
KBMC/20/0005
KBMC/19/0006 - THIS IS WHEN BACKDATED YEAR WAS ENTRED
what I am expect the outcome should be like this
KBMC/19/0001
KBMC/19/0002
KBMC/19/0003
KBMC/20/0001 - THIS IS DIFFERENT DATE/YEAR
KBMC/20/0002
KBMC/19/0004 - suppose it follow year sequential.
thanks in advance for help and guide.
Bookmarks