drop down list on other sheet?
 

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.

drop down list on other sheet?
 

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




In article ,
dlw wrote:

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.