Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
create drop down list from different workbook
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
create drop down list from different workbook
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
create drop down list from different workbook
You should realize though, that the "other" WB *must* be open for the DV
list to work. If you still want to try this, you must assign a name to the range in the source WB that the target WB can recognize. To do this, open *both* WBs. In the 'target' WB, <Insert <Name <Define In the "Names In Workbook" box, enter: ValidDepts Select the *entire* contents of the "Refers To" box (turns black), And navigate to the source WB, and select the range of cells that contains your data list. Click <OK This brings you back to the target WB. NOW ... set-up your drop-down list. <Data <Validation <Allow, click on "list". In the "Source" box, enter: =ValidDepts Then <OK And you're done! Don't forget, both WBs must be open for this to work. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Brett" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Drop Down List | Excel Discussion (Misc queries) | |||
Limit drop down list and linking to other info | Excel Worksheet Functions | |||
Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
how do i create a find function for an excel drop list? | Excel Discussion (Misc queries) |