sudipballa
New Member
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
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