Singling out searched cells
 

I'm creating a customer database, and I would like to be able to search for
values and ONLY show those that match. For instance, if I search for Apples,
I only get the lines with cells containing "Apples". Right now, with ctrl + F
it only shows me where they are in the document, I need it to acutally
isolate the rows.

Singling out searched cells
 

If all instances of Apples would be in one column use
DataFilterAutofilter.

If more complex than that post back with some details.

Could Apples be in several different columns?

Could Apples appear twice in the same row?


Gord Dibben MS Excel MVP

On Mon, 26 Oct 2009 11:36:04 -0700, Lycean
wrote:

I'm creating a customer database, and I would like to be able to search for
values and ONLY show those that match. For instance, if I search for Apples,
I only get the lines with cells containing "Apples". Right now, with ctrl + F
it only shows me where they are in the document, I need it to acutally
isolate the rows.