Need Help to Select certain Data from my spread sheet.

[Gmata]

Hi,

I need some help to figure out a way to select certain data from my
spreadsheet.
Here is what i need.

I have an inventory of diferent items each has diferent information for
example

Title Description Brand Price Picture

I want to select all the items for just a number of brands
for example I have 10 brands and i only want the products that their brand is:

Blue
Green
Red
Yellow

and delete the rest of the products that their brand is not one of those 4.

Any help? i am trying to create something than can do it automaticly like a
macro.
Thanks

 

[Spiky]

Hi,

I need some help to figure out a way to select certain data from my
spreadsheet.
Here is what i need.

I have an inventory of diferent items each has diferent information for
example

Title Description Brand Price Picture

I want to select all the items for just a number of brands
for example I have 10 brands and i only want the products that their brand is:

Blue
Green
Red
Yellow

and delete the rest of the products that their brand is not one of those 4.

Any help? i am trying to create something than can do it automaticly like a
macro.
Thanks

Data menu:Filter:Advanced Filter

If it is always the same 4 or whatever brands, record what you do as a
macro and that should be usable without tweaking or anything. If the
brands you want vary, maybe just set up an Advanced Filter to a
different location. You can adjust the brands when you need to in the
future, and re-run the Filter when necessary.

 

[Gmata]

I use the filter option but there actually about 160 brands i need, and when
i run the macro it says: "Too Many Line Continiuations"
What can i do about that?

 

[Spiky]

Huh. That is not an error I'm familiar with, so hopefully someone else
is. Perhaps there is a different way to write your macro if you've
just run up against a limitation of some sort. If you post your code,
someone can probably trouble-shoot it.

Although, if you do a filter without the macro, it does work. Even
with 160 items. You just have to enter them all in as criteria.