Need Help to Select certain Data from my spread sheet.
 

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

Need Help to Select certain Data from my spread sheet.
 

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.

Need Help to Select certain Data from my spread sheet.
 

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" wrote:

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.

Need Help to Select certain Data from my spread sheet.
 

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.