G Guest Jul 15, 2004 #1 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
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
G Gordon Jul 16, 2004 #2 Mark said: I want to know if it's possible to have a drop down box on one page and Click to expand... 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....
Mark said: I want to know if it's possible to have a drop down box on one page and Click to expand... 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....
D Debra Dalgleish Jul 16, 2004 #3 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
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
