When I want to find all instances of a particular item in an Excel database
and I use the "Find All" option what I get is a window with columns Book,
Sheet, Name, Cell, Value & Formula. For example; In a music database I keep
with the columns Artist, Title & Disc and I searched on "Motown", what I want
to get back would be all the tracks of all the artists on a disc with
"Motown" in the title. But what I get is the name of the database in the
"Book" column, the sheet the database is on in the "Sheet" column, nothing in
the "Name" column, the cell the word "Motown" appears in in the "Cell"
column. How do I get a list that doesn't only show a list of cells the
search word appears in.