Caireview, did you ever find an answer to your question? I am having the same
issue with my spreadsheets and I honestly didn't quite understand the answer
you recieved from Mike. Can you help? Thanks- Roxy

"ClaireView" wrote:

My co-worker wanted to avoid entering duplicates in her Excel 2002 document.
I was very proud of myself for discovering Data Validation, and that worked
fine. Now the problem is harder:

She has one workbook and every day she adds a new worksheet to it. She
wants to make sure the data she's entering wasn't also entered on a previous
day. This is beyond me. Any ideas?