I am attempting to use a drop down list which is located in a separate
workbook. I've gone through the directions several times by using the help
menu "Create a drop-down list from a range of cells" When I get to the last
step which is entering the source, I get a pop up message which says "You may
not use references to other worksheets or workbooks for Data Validation
criteria" This is confusing because it specifically shows how to use separate
notebooks. Help anyone!