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