Hi all - i am trying to improve a register that is used at work. in column A a macro inserts into the next blank cell a unique ID e.g. PCR21040.
PCR = hard coded - never changes
21 = current year - taken from last 2 digits of year in cell Q1
040 = is the last entry for that year (could be any amount... just depends)
how can i get the counter easily to reset to PCR22001 when the year changes? and obviously this happens each year that passes
TIA
PCR = hard coded - never changes
21 = current year - taken from last 2 digits of year in cell Q1
040 = is the last entry for that year (could be any amount... just depends)
how can i get the counter easily to reset to PCR22001 when the year changes? and obviously this happens each year that passes
TIA