Hey guys I'm having a bit of trouble with a formula for barcodes.

I'm trying to get a sequence eg.

eg I will scan this barcode: HD65B1164281P
and it will go up like this HD65B1164282P
283P

for ten barcodes then i will scan another barcode and it needs to go into another sequence for 9 barcodes....etc

Any help would be appreciated.