About filter

J

juanpablo

Hello,

I have the following question: If I want to fill a different sheet using the
information on Sheet 1 as source.
For example on Sheet 2, I want to select from a list, apples on column A and
automatically on column B I want to select also from drop down list only the
information asociated to apples, like box z, and Column C only information
asociated to apples, using box w.

Sheet1
A B C D
apples box z 25 units labeled PF
apples box z 50 units labeled PF
apples box w 50 units labeled TR
lemmons box y 100 units labeled LM
lemmons box y 100 units labeled LM
grapes box x 200 units labeled GR
grapes box x 250 units labeled GR
grapes box x 300 units labeled GR

How can I do it?

Thanks
JP
 
C

CLR

Data > Filter > Autofilter........select the dropdown arrows and choices on
your columns of interest.....

Vaya con Dios,
Chuck, CABGx3
 
C

CLR

Sorry, forgot to mention that when you are finished viewing the filtered data
you can do Data > Filter > Autofilter again and it will return everything to
normal.....like a toggle.......

Vaya con Dios,
Chuck, CABGx3
 
T

Terry Tipsy

I'm not really sure what you are after, but 'Auto Filter' works well for the
sample you have given. You may also want to consider using a 'pivot table.'
Pivot tables are a good way to analyze data and select specific records from
a large group.
 
J

juanpablo

Yes, but the filter would go on sheet 2, and the data is on sheet 1, how do i
proceed?
 
J

juanpablo

But on Sheet 2 I dont want to have all the information displayed,

Sheet 2 should look like this
A B C D
fruit packing qty label

and from below the fields, a drop down to select.

JP
 
J

juanpablo

Hi,

The autofilter wont work, what I want to do is on sheet numer two, select a
cell and from a drop down list, choose the desired items.
Will work a query with ODBC?
 

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