Question: How to avoid duplication in excel workbook. Suppose if the
name of the company is (ABC Inc.)entered in one sheet, and while
entering the same company name(i.e. ABC Inc.) in other sheet, the
excel should show a message that the company name already exist in
so and so sheet name.

Please provide me the detailed answer along with the required tools
to solve the above problem.