Preventing Duplicates

Hi,

Is there anyway to stop the below code producing duplicates?

Please Login or Register  to view this content.

Any help greatly appreciated

Hi,

hard to tell without any example data, could you provide some?

Regards

Breakdown_Excel.xlsm

Hi tehneXus, thanks for the reply, here is some sample data, if you run the module you will see what I mean when duplicate rows appear due to products repeating during the breakout. Thanks

There is a stray end if in that attachment. My apologies. You will spot it when you try to run. Thanks

Hi,

OK, you are separating the semicolon separated elements into records, looks fine for me. How should the table look after running the macro?

Regards