Excel Duplicate Cell Search and further analyse Data using VBA

Hi,

I have an excel sheet with data from Column 'A' to 'S'.

I want to identify duplicate entries in Column 'J' and from those identified columns I want to further search Column 'K', highlight the matching text and then fill text in Column 'L' should have the missing data after matching the 'A' and 'K' cells.excel_duplicate_enteries.png

Regards,
~Deep

Please send an excel sample file in its original state.

Maybe:

Please Login or Register  to view this content.

excel_duplicate_fill_data_sample.xlsx
Sample file attached.

Thank you for looking into it.

Modified based on your new sample.

Please Login or Register  to view this content.

Thank you John for your quick response and it really worked for me.

A small change which I want to accommodate is -

Values in Column 'B' are constant for example "Data1", "Data2" and "Data3". I would like to match data in Column 'A' which is happening and Column B based on "Data1", "Data2" and "Data3". Column C should populate the values (if empty in Column 'C') based on the matching criteria of 'A' and 'B'.

Hope I am clear in my requirement and sorry for the churn for asking again.

Regards, ~D

You're welcome. Can you provide another sample as you previously did with the comments showing what your layout will now look like and what you'd like to happen?

excel_duplicate_fill_data_sample.xlsm

Thanks John for helping me.

Attached here is the excel sheet with my comments.

Hope it helps!

Regards,
~D

Maybe:

Please Login or Register  to view this content.

This doesn't work the way I expected.

It is matching the criteria from column 'a', finding the duplicates then filling the column 'c' with column 'c' header value.

Also, it is not validating the column 'b' but replacing values in column 'c' based on duplicates found in column 'a'.