If there a way to tell excel to search within the same workbook for
multi-entry of same text. Want I'm trying to do if check to make sure that
the spreedsheet doesn't have double entry of the same information. Can excel
do that and if so how do I make it happen?
Thanks to anyone that replies

hi,
see this site.
http://www.bmsltd.ie/MVP/
they have a free addin utility call flexfind that will
search all sheets for selected text or numbers.
this utility is built into xp and above. not sure about
2002. i jumped from 2k to xp.

-----Original Message-----
If there a way to tell excel to search within the same
workbook for
multi-entry of same text. Want I'm trying to do if check
to make sure that
the spreedsheet doesn't have double entry of the same
information. Can excel
do that and if so how do I make it happen?
Thanks to anyone that replies
.

anon

Info only.......Excel XP version is Excel 2002.

Newest version is 2003.


Gord Dibben Excel MVP

On Wed, 9 Feb 2005 06:45:53 -0800,
wrote:

hi,
see this site.
http://www.bmsltd.ie/MVP/
they have a free addin utility call flexfind that will
search all sheets for selected text or numbers.
this utility is built into xp and above. not sure about
2002. i jumped from 2k to xp.

-----Original Message-----
If there a way to tell excel to search within the same
workbook for
multi-entry of same text. Want I'm trying to do if check
to make sure that
the spreedsheet doesn't have double entry of the same
information. Can excel
do that and if so how do I make it happen?
Thanks to anyone that replies
.