About filter

[Guest]

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

 

[Guest]

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

Vaya con Dios,
Chuck, CABGx3

 

[Guest]

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

 

[Guest]

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.

 

[Guest]

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

 

[Peo Sjoblom]

Use copy an paste, filter on sheet1 and then copy and paste to sheet2

 

[Guest]

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

 

[Guest]

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?