Advanced Search Capability

[Fred Holmes]

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.

 

[Dave Peterson]

#1. Hit the shift key when you click the Find next button.
#2. I'm sure there is, but I don't have the name/location.
(Maybe someone will jump in with a suggestion.)
#3. Here are a few...

Ron de Bruin's EasyFilter addin:
http://www.rondebruin.nl/easyfilter.htm

Or:

Code from Debra Dalgleish's site:
http://www.contextures.com/excelfiles.html

Create New Sheets from Filtered List -- uses an Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter. AdvFilterRepFiltered.xls 35 kb

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- replaces old data with current.
AdvFilterCity.xls 55 kb

 

[Dave Peterson]

Ps. For #3, if I just have to do it once every so often, I'll just filter the
range. Show the rows I want and copy the visible rows and paste to the new
location.

 

[Fred Holmes]

#1. Hit the shift key when you click the Find next button.

Duh! Why is it I never think to try such things? Because other
dialogs (other apps) have separate buttons for "Next" and "Previous."

Many thanks,

Fred Holmes