How to produce a consolidated list based on selection criteria?

[CRS]

I could use some help on this one ...

In column A I have a long list of alphanumeric entries (they happen to
be record titles), and in column B I have a corresponding list of
TRUE/FALSE entries generated by applying a selection criterion to column
A (typically, looking for a word contained in the record title).

So far so good. Now, on a separate worksheet, I want to produce a
consolidated list of those titles matching the selection criterion (i.e
a consolidation of those entries that have a TRUE value against them).
So, if from a total list of say 500 entries, 10 match my selection
criterion, I want to list those 10 entries in rows 1 to 10 of the second
worksheet.

Can this be done without resorting to VBA, copy/paste/sort, etc?

Many thanks in advance for any advice, and Merry Xmas to everyone.

CRS.

 

[Don Guillett]

Try using data>filter>auto filter

 

[Debra Dalgleish]

You can use an Advanced Filter to extract the items to another sheet.
There are instructions here for setting up the table and criteria range:

http://www.contextures.com/xladvfilter01.html

and for filtering to another sheet:

http://www.contextures.com/xladvfilter01.html#ExtractWs

 

[CRS]

Don/Debra - many thanks; that's given me some ideas.

CRS.