I suggest you start with Chip's site
www.cpearson.com which has lots about
duplicates
Then come back with more detailed question
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"wally" wrote in message
...
In a workbook I have a worksheet for each month of the year. How would I
be
able to automatically determine whether the entry currently being made has
been entered in the same column previously on any of the worksheets?
(Similar to "Find" under Edit) If so, would it be possible to indicate
the
previously entered data by highlighting each duplicate cell?