Bringing data from a table

  • Thread starter Thread starter yanf7
  • Start date Start date
Y

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!!
 
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.
 
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.
 
Back
Top