Autofilter from a separate worksheet

[Guest]

I want to know if it's possible to have a drop down box on one page and have the info within it on a separate a page??? thanks

 

[Gordon]

I want to know if it's possible to have a drop down box on one page and

have the info within it on a separate a page??? thanks

You can select all the data in the autofilter window and then copy and paste
onto another page - that's about all you can do AFAIK....

 

[Debra Dalgleish]

If you want a dropdown list of items, you can use data validation. Name
the range of cells on the other sheet, and you can refer to them in the
data validation dialog box.

There are instructions here:

http://www.contextures.com/xlDataVal01.html

 

[Guest]

awesome thanks, i checked it out and it was what i was looking for.