About filter

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Data > Filter > Autofilter........select the dropdown arrows and choices on
your columns of interest.....

Vaya con Dios,
Chuck, CABGx3
 
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
 
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.
 
Yes, but the filter would go on sheet 2, and the data is on sheet 1, how do i
proceed?
 
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
 
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?
 
Back
Top