Hello,
I am using Excel 2007 and I am trying to add a Drop Down List using a list from another workbook.
Excel help says this can be done but after following the steps given I recieve the message "You cannot use references to other worksheets or workbooks for Data Validation criteria".
Can anyone help me with this problem?
Thank you in advance.
Configuration: Windows Vista Internet Explorer 8.0
Change excel drop down list based on choices Declaring a drop down list in excel using vba Download excel format for data entry Download list of all dos command Drop down list default choice html Excel 2003 "drop down list" autofilter range Excel add drop down list and access database Excel drop down list button will not display Excel drop down list of sheet names Excel drop down list with if Excel drop down selection using keyboard Excel file download security warning Excel reader download Excel to pdf converter full version free download Format a 4gb micro sd in fat change file system drop down How connect one drop down list with another in excel Select from drop down list excel macro When i save an image from the internet, the drop-down bar with the file type is blank