Drop down lists

S

sarahledwards

im updating my database and there are several columns that have drop down
boxes and i use the auto filter a lot to sort the data so when its all sorted
it throws the sources/info in the drop down boxes out, so nothin appears how
do you have all the information on another sheet so that dont happen
 
O

Otto Moehrbach

Sarah
I think you are asking if and how you can have a list in one sheet and
use that list in a Data Validation cell in another sheet. Is that right?
If so, yes, you can. First, name the list, say, MyList. Then when you
setup the Data Validation cell, select List, then in the source box, type
"=MyList" without the quotes. HTH Otto
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtered drop down list 2
Making Drop Down Box Visible with Excel 2003 2
Conditional Drop Down Boxes 1
Drop down list ???? 1
Drop Down List 3
Autopopulate a drop down list in Excel 2
Using drop down lists 2
how to delete drop down boxes 2

Top