Hello,

I have a long list of alphanumeric values (i.e. BB235) that is comprised of multiple value sequences. For example, one sequence may be C3345 to C3399 and then the sequence will jump to JB900 to JB979. I would like to design an excel macro that would automatically insert rows and the missing values in a sequence based on rows that I highlight.

Any tips or advice would be much appreciated, even if it is only to tell me that it cannot be done.