Is there any code out there (add-ins, macros, etc.) to provide
advanced search capabilities in Excel (2000, or any other version)?

1. The ability to search backwards, or at least a command button to
go to the "previous hit" instead of the "next hit"?

2. The ability to use regular expressions or any sort of andvanced
search string (something better than just wild cards)?

3. The ability to process a list, and copy every row that meets the
search criteria to another worksheet, thus producing a condensed list
of the hits?

Have their been improvements in the search capability with later
versions of MS office. I have a machine with Office 2007, but don't
use it because I haven't gotten used to the new interface yet, and it
doesn't seem to have any "killer" capabilities in it.

TIA

Fred Holmes

I could probably write the vba macro for #3, but would love to not
have to. "Previous hit" could perhaps be kludged by first counting
the number of hits in the entire worksheet, and then stepping n-1 hits
forward, but that's a kludge, and might be very slow for a large
worksheet.