On Sep 2, 12:18 pm, Gmata wrote:
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.