How to produce a consolidated list based on selection criteria?

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.

Try using datafilterauto filter

--
Don Guillett
SalesAid Software

"CRS" wrote in message
...
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.

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 wrote:
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.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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

CRS.