I have a similar issue. My job involves a number of prefixes used for different items. These prefixes are created by a program specifically for this purpose.
The prefixes consist of four alphanumeric chapters on an ascending cycle from 0-9 and continuing with A-Z. EG: 0,1,2...8,9,A,B... and must be all caps. One may look like 5NB2 or DT3A, just to lend a visual. Much of the current practice is mind-numbingly tedious, as you can imagine.
We are well into the cycling and I want to create two sets of columns, or one longer column, so that I only need to enter the first in a new sequence to accurately complete the sequence either automatically or by dragging. Rather than c/p 80 of them one by one.
Can this be done as well? If so, please show me how I can set this up. Thank you!