batch sequence

Hi all,

I am trying to generate a batch sequence in XL.

Batch sequence is a fixed prefix of one cell (xxxx) which is the offer nr. (CEL D1)

Following that is a string of 3 digits which represents the lot number. The lot number consists of the amount of models given in column C after this number is completed it is then the next 3 digit lot for the amount of time given in column C.

Sequence needs to be generated in column I, as per example.

C

(2)xxxx-001
xxxx-001
(1)xxxx-002
(1)xxxx-003
(3)xxxx-004
xxxx-004
xxxx-004

and so on


I am looking for a formula to do this, since currently this is done manually "bleh" for about 1300 lines.

I am sure there are better solutions for this