Yes, you can reference a DV list on another sheet. You'll need to create a
Range Name for the list. You miight even want to create a Dynamic Range Name.
See Debra Dalgleish's website for instructions.
Start he
http://www.contextures.com/xlDataVal01.html
Does that help?
***********
Regards,
Ron
XL2002, WinXP
"Michael Kintner" wrote:
Is it possible to create a drop down list in a cell that looks at a range of
values on a different sheet?
Mike