vba to concatenate data and return multiples values from unique list

Hi all

I have a database of 75000 rows actually and it continues to expand daily.

Some products have different statistics code and description.

On the right are unique items with compilation of different statistics code and description in one cell as per database .

The item no is unique that needs to taken in account for unique list

looking a vba code to speed up process in one cell as per attached



Thanks if anyone can assist

It is unclear if you want to remove dups in columns A & B or use column H to make unique columns A & B.

Originally Posted by Kenneth Hobson

It is unclear if you want to remove dups in columns A & B or use column H to make unique columns A & B.

Yes to remove dups in A and B but the column A to D should remain as it is , because it the database so there are unique in columns F and G .

However at column H there are unique of column C and D which are concatenated and give a summary details.

My goal is have unique list column A & B at column F& G.
then for column H unique for C and D concatenated

Hi Mike

We are on the right track,but need a little tuning

See as per attached sheet 2 for more explicit explanation

Actually for reference 0055767 the tariff description is merging all

should read as below as unique

0055767 .B / POIGNEE CLASSQ VERNI HETRE E128 L170 83024100 BASE METAL FITTINGS,83024100 BASED METAL MOUNTINGS

See attached sample sheet for ease

It there were trailing spaces it would have taken it but there are no trailing spaces as it should be unique.

thanks if you could adjust code as unique for header tariff description for column H

Here's how I read your problem

Please Login or Register  to view this content.

I am bit confused

should I changed as below,otherwise kindly show me amended complete coding.

Trying but getting compile error

Please Login or Register  to view this content.

TO read this

Please Login or Register  to view this content.

Jindon &Mikericson

Thank you for both solution it takes a bit of time but at least it is done correctly and this saves a lot of time than doing this manually

Jindon &Mikericson

Thank you for both solution it takes a bit of time but at least it is done correctly and this saves a lot of time than doing this manually