URGENT - Duplication Process

[t5timesb]

I need help with creating the following operation:

Finished Good 1	0	A
Finished Good 1	1	B
...	...	...
Finished Good 1	20	U
Finished Good 2	0	A
Finished Good 2	1	B
...	...	...
Finished Good 2	20	U
Finished Good 30,888	0	A
Finished Good 30,888	1	B
...	...	...
Finished Good 30,888	20	U

<tbody>
</tbody>

Column A is duplicated and then changed to the next in order. Column B & C remain the same. Column B stays 1-20. Column C is the same for the 20 rows, but is not actual "A", "B"..."U".

 

[Gilliam]

are you running the macro when the sheet with the finished goods are listed in order?
Are those finished goods in column A?
do you already have a sheet named finished goods?, if so, delete it and then run the macro again.

 

[t5timesb]

I am on a XLSM (thank you Andrew)

I split up the 30,888 rows and that removed the crash, however, I am still getting consecutive numbers:

FW15RH20.KBSTVS.GDRB60
FW15RH20.KBSTVS.GDRB61
FW15RH20.KBSTVS.GDRB62
FW15RH20.KBSTVS.GDRB63
FW15RH20.KBSTVS.GDRB64
FW15RH20.KBSTVS.GDRB65
FW15RH20.KBSTVS.GDRB66
FW15RH20.KBSTVS.GDRB67
FW15RH20.KBSTVS.GDRB68
FW15RH20.KBSTVS.GDRB69
FW15RH20.KBSTVS.GDRB70

vs
FW15RH20.KBSTVS.GDRB60
FW15RH20.KBSTVS.GDRB60
FW15RH20.KBSTVS.GDRB60
FW15RH20.KBSTVS.GDRB60
FW15RH20.KBSTVS.GDRB60
FW15RH20.KBSTVS.GDRB60
FW15RH20.KBSTVS.GDRB60
FW15RH20.KBSTVS.GDRB60
FW15RH20.KBSTVS.GDRB60
FW15RH20.KBSTVS.GDRB60
FW15RH20.KBSTVS.GDRB60

 

[t5timesb]

Thank you!