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

Vaya con Dios,
Chuck, CABGx3



"juanpablo" wrote:

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