Hi!

This is relatively easy to do with formulas but try
Frank's suggestion first and see if that's what you really
want.

If you decide you want to go the formula route, just post
back and "we'll" fix you right up!

Biff

-----Original Message-----
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.
.