drop down list on other sheet?

D

dlw

I can't have a drop down list refer to a range on another sheet in Excel 2000?
Do more recent versions let you do that?
Interesting, instead of programming it to do that, they program it to tell
you that you can't do that.
 
J

JE McGimpsey

You can use a list on a separate sheet in Data/Validation if you name
the list (say, "MyList"). Then choose Data/Validation, Allow:List,
Formula: =MyList
 
Top