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


--
Regards,

Peo Sjoblom


"juanpablo" wrote in message
...
Yes, but the filter would go on sheet 2, and the data is on sheet 1, how
do i
proceed?

"CLR" wrote:

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



"CLR" wrote:

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