Brett

Check out the steps Debra Dalgleish outline here.

http://www.contextures.on.ca/xlDataVal05.html


Gord Dibben MS Excel MVP

On Thu, 17 Aug 2006 12:49:02 -0700, Brett
wrote:

i followed the directions to create a drop down list on one workbook with
criteria from another workbook with data validation (as the directions stated
from the help section"Create a drop-down list from a range of cells "). when
i enter the name of the reference (=ValidDepts), i get an error message that
says, "you may not use references to other worksheets or workbooks for data
validation criteria." can someone help me with this?

Much Thanks