Dear,

I need an option where in a cell if some text data is entered, it should
validate the value entered from a range of cells within the same sheet/from a
different sheet of an excel and should correct the name (if wrong) or retain
the same (if correct).

Hope my query is clear.

In detail.. I have a list of company names around 200 and when i extract
data which has company names, and paste it in a range of cells it should
validate the company names from the source and corect or retain.

Please help.