Duplicate check with VBA code

[jgopalk]

Hi All,

I wanted to create <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-top-style: initial; border-right-style: initial; border-bottom-style: dotted; border-left-style: initial; border-top-color: initial; border-right-color: initial; border-bottom-color: rgb(0, 0, 0); border-left-color: initial; border-image: initial; cursor: help;">VBA</acronym> code for highlighting duplicate words in Sheet 2 with refer to sheet 1. Sheet 1 has master list. Sheet 2 has minimum values, which has to be compared and highlighted if any word found in sheet 1.

Example:
Sheet 1

Jasmine

Lotus

Lilly

Ladies finger

Carrot

Bird of Paradise

<tbody>
</tbody>

Sheet 2:

Jasmine

Ladies

Paradise

Blue bell

Jack fruit

<tbody>
</tbody>

After macro, answer should be:
Sheet 2:

Jasmine

Ladies

Paradise

Blue bell

Jack fruit

<tbody>
</tbody>

Note: Dupe does not need to be a exact one. For example, Master list has "Ladies finder", but in my sheet 2 i have added "Ladies" alone and it also should be highlighted.

Thanks in advance for your time in this.

Gopal​

​

 

[jgopalk]

Anyone could help me to fix this issue?

 

[jgopalk]

99% of the work finished in this. 1 % alone pending. Kindly anyone check to finish this.

 

[jgopalk]

Someone kindly try this.