Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I set up drop-down list for a cell when the list is in ano.
I am trying to create a drop down list for a cell where the data is in
another workbook. I followed directions from the on line help for Create a drop-down list: I defined a name in the INSERT/NAME/DEFINE prompts. Then I went to the VALIDATION/Settings prompts. when I enter the name I created in INSERT/NAME/DEFINE section, click add, then close it comes back and tells me I cannot use references to other worksheets or workbooks. --- Help, what am I doing wrong? |
#2
|
|||
|
|||
There are instructions here for using a list in another workbook:
http://www.contextures.com/xlDataVal05.html redsunjvd wrote: I am trying to create a drop down list for a cell where the data is in another workbook. I followed directions from the on line help for Create a drop-down list: I defined a name in the INSERT/NAME/DEFINE prompts. Then I went to the VALIDATION/Settings prompts. when I enter the name I created in INSERT/NAME/DEFINE section, click add, then close it comes back and tells me I cannot use references to other worksheets or workbooks. --- Help, what am I doing wrong? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
Debra Dalgleish has some instructions, but read the warnings!
http://www.contextures.com/xlDataVal05.html redsunjvd wrote: I am trying to create a drop down list for a cell where the data is in another workbook. I followed directions from the on line help for Create a drop-down list: I defined a name in the INSERT/NAME/DEFINE prompts. Then I went to the VALIDATION/Settings prompts. when I enter the name I created in INSERT/NAME/DEFINE section, click add, then close it comes back and tells me I cannot use references to other worksheets or workbooks. --- Help, what am I doing wrong? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
automatic color change in cells using a drop down list | Excel Worksheet Functions | |||
Removing a drop down list from a cell | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions | |||
Drop List Referencing | Excel Worksheet Functions | |||
Place a set value in a cell from a drop down list name reference | Excel Worksheet Functions |