Autofilter from a separate worksheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mark - 15 Jul 2004 23:48 GMT

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

Reply to this Message

Gordon - 16 Jul 2004 00:21 GMT

> 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....

Reply to this Message

Debra Dalgleish - 16 Jul 2004 00:44 GMT

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

> 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

Signature

Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Reply to this Message

Mark - 16 Jul 2004 02:34 GMT

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

> 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
[quoted text clipped - 5 lines]
>
> > 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

Reply to this Message