Need Vba Code to find Same Text comparing two columns

Hi,

I Need a vba code that will compare "Specific text" in two columns and will return "Ok" in a new column

for example:

Column
A1: Notebook Computer
B1: Notebook Computer BC3453

Column
A2: Desktop Computer
B2: Desktop Computer 902483

here it will match the text Notebook Computer in A1 and B1 and Desktop Computer in A2 and B2


Required result

in Column C it should return
C1: Match OK
C2: Match Ok

Assuming the data stays consistent in the format provided, maybe this could work:

Please Login or Register  to view this content.

Originally Posted by Kamboj

USE THIS CODE

Please Login or Register  to view this content.

Hello Kamboj,
Your code works but limited for use in sheet1 only?

Another:

Please Login or Register  to view this content.