Excel macro and VB

Job ID: 30892347

Budget: ₹12,500 – ₹37,500 INR

We are a Pharma services company and work on knowledge area with huge data and information .
We are looking for someone who can help set up a Excel macros with VB application .

This IME macro has 2 excel sheet, one is blank (Sheet 1) and another one has all the important medical event (Sheet2).
So when we copy paste article in to sheet 1 and run macro, so all the important medical event will get highlighted in Red or in some other color present in the article which is already there in sheet 2.

Sheet 2 is already attached here with, VBA person has to write some VBA code in the macro, so that when we copy paste article in to sheet 1 and run macro all the term which is present in sheet 2 will get highlighted in sheet 1.

Please let us know if it is possible