ClaireView,

Take a look at "Data across multiple sheets" at
http://www.smokeylake.com/excel/excel_truths.htm. Don't be too quick to dismiss it -- it
might pay off in the long run to keep the data consolidated.
--
Earl Kiosterud
www.smokeylake.com

Note: Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------
"ClaireView" wrote in message
...
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?