VBA copies rows based on specific items in a column but need to rename items created

Hi,

I'm using excel 2003 and have attached the file complete with the VBA shown below, it works fine except I need it to rename the items in the rows that it's duplicating.

Please Login or Register  to view this content.

I hope this makes sense and thanks for any help,

David

Not sure if this is how you wanted.

Please Login or Register  to view this content.

Hi jindon thank you but it does not work for the MPL002 which is 3 items instead it creates an additional line with MPL002-3 on it own.
I have attached the order.xls file with you new code and as you can see it when run it does not create the 2nd line for the MPL002

Thanks again for your help,

David

OOps,

Can you change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Perfect! thank you very much for your help.

You are welcome.