Bringing data from a table

[yanf7]

I have a table that has this data:
FALSE Audiovox 8100
FALSE Audiovox 9000
FALSE Audiovox 9200 carry
FALSE Audiovox 9300
FALSE Audiovox CDM8150
FALSE Audiovox CDM8300
FALSE Audiovox CDM8900
FALSE Audiovox Thera
TRUE KY7135
FALSE Kyocera 6035
TRUE Kyocera KE424
TRUE Kyocera KE424C
FALSE LG 5450
FALSE LG TM520
FALSE Motorola 2900

I want to bring to a new table only values from column B that have Tru
near them in column A.
Please help!!

 

[Debra Dalgleish]

You can use an AutoFilter (Data>Filter>AutoFilter) to select the rows
with TRUE in column A. Then copy the visible rows, and paste onto a new
sheet.

There are instructions here:

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

 

[Ronnie Brysland]

If you do this with a macro it will work ok except if all
the entries have FALSE in column A, it will then copy all
data to the new sheet. You could copy all the data to the
new sheet first, do the AutoFilter to show False only
then delete these rows. You should then be left with the
rows showing TRUE if there are any.

 

[Dave Peterson]

I think it would depend on how you wrote your macro (if it would copy all the
data to the new sheet).

And another way would be to sort the table and just copy the range you want.