VBA Code Needed..using Concatenate & Compare Duplicates

[naven_sg]

Hello all,

I need a Macro coding for the below situation:

Macro should Concatenate the text in ID & Track...compare with the other ID& Tracks for Duplicates and should print only the once if there is any Duplicate.

I have attached sample file.

Thanks for all the assistance.

Regards,
NG

[Leith Ross]

Hello naven_ng,

Welcome to the Forum!

The following macro has been added to the attached workbook. The table on "Sheet1" has been copied to "Sheet2". A button on "Sheet2" will run the macro and modify the "Sheet2" table. You can change the worksheet and the starting range (first cell below the header) if you need to in the macro. These have been marked in bold text.

Please Login or Register  to view this content.

[naven_sg]

Thanks lot Ross...Appreciate all your help.

Sorry...I know the issue is resolved. But when reply to this thread i did not get that option.

Regards,
naven_sg

[naven_sg]

Ross..Thanks for the update.

But I just small correction to the coding. I thought of editing my self, but with no success.

The appearance of the data is bit diffrent what i have provided earlier.

I have attached excel file with data. Can you please help me out.

Thanks for all your help.

Regards,
naven_sg

[Leith Ross]

Hello naven_sg,

I updated the macro. There is one significant change to the worksheet. A new column was added "C". This column contains no data and is hidden. The reason for this was to maintain groups of three cells across. Here is the updated macro that has been added to the attached workbook.

Please Login or Register  to view this content.