Duplicate RECORDS - Macro Requested

Hello Experts

I am prepared Data Load files and looking for a macro:

In attached file, you will see few records for Co Code 1000. (In this sample, you are seeing 3 records, in reality we have 1900 records and 15 fields.)

CoCode GL GL Name Field1 Field2 Field3
1000 549082 Samples TXT 1 121
1000 549099 Demos NUM 2 121
1000 549789 Lab TXT 1 2


I have a list of 55 Co Codes(Say 2000,2001,2002,3000,...) for which i want to duplicate the same data, only CoCode will keep changing

Can i specify this list of Co Codes in a different sheet or same sheet in a different column, and run the macro so that it duplicates all the records for all these co codes

Thanks
Kishore

Either start here: https://www.excelforum.com/excel-pro...materials.html


or go here: https://www.excelforum.com/commercial-services/