Need Help to Select certain Data from my spread sheet.

G

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
 
S

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.
 
G

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?
 
S

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top