Hi
you may have a look at the following addin:
http://www.rondebruin.nl/easyfilter.htm

--
Regards
Frank Kabel
Frankfurt, Germany
"Brad" schrieb im Newsbeitrag
...
My mother created at a spreadsheet to document all her movies. The
columns
include TITLE, GENRE, RELEASE DATE, and 12 separate columns for actors
(ACTOR_1, ACTOR_2, etc.). She has a second sheet in the workbook, with
all
the actors listed. This has 3 columns (Name, Movie Title, and Release
Date).

I'm adding my collection to her 'database' and she's mad that I won't
enter
anything on the "ACTORS" sheet. If I'm looking for a specific actor, I
just
use FIND, and FIND ALL to see what movies we have that they were in. The
question; is there a way to export the find results to a separate sheet?
Or
a function/tool in Excel that would search across mutliple columns (for
all
instances of Kevin Spacey) and easily show what movies we have that have
him?
Does this question make sense?

Thanks to anyone who can help.