Take a look at

http://cpearson.com/excel/duplicat.htm


In article <F87E0D91-E192-42EC-A8BA-E1FEC70CCB6E@microsoft.com>,
"DLee" <DLee@discussions.microsoft.com> wrote:

> I have created a database which has been worked on by someone else.
>
> I have made the necessary alterations but how do I check for duplicate
> entries on each worksheet.
>
> Thansk