rubbercheck
10-21-2010, 06:50 PM
Hello all,
I hope someone will be above to help me with this one. Every month I get our delivery service bill in MicroSoft Excel (cvs format); Column A has the codes of companies sometimes separated by semi colons or comas.
I would like a macro that can repeat the lines if it has more than one code and copy it to another sheet. Eg, A2 has 6 company codes so it should be copied to another sheet, and divide the amount in J2 in each row. If it had one code it would also be copied to the other sheet.
See what the result should look like on the Summary worksheet.
Thanks in advance
Rubber c
I hope someone will be above to help me with this one. Every month I get our delivery service bill in MicroSoft Excel (cvs format); Column A has the codes of companies sometimes separated by semi colons or comas.
I would like a macro that can repeat the lines if it has more than one code and copy it to another sheet. Eg, A2 has 6 company codes so it should be copied to another sheet, and divide the amount in J2 in each row. If it had one code it would also be copied to the other sheet.
See what the result should look like on the Summary worksheet.
Thanks in advance
Rubber c